Floating Point Normalisation

by Richard Pawson

Download the spreadsheet

A sophisticated spreadsheet (Excel) that allows you to explore the difference between a normalised and non-normalised floating point number (represented in the format used by AQA). You can enter a number and the spreadsheet will state whether this is in normalised format, and if not, show you the normalised version. It also calculates the absolute and relative rounding error in each case.