Numeric precision in Microsoft Excel: Difference between revisions

Revision as of 02:44, 5 October 2016

Revision as of 12:36, 14 February 2017

Line 91:

:<math>B2: = A2 - A3</math>

Both cells <math>B1</math> and <math>B2</math> display <math>1.1530</math>.

However, if cell <math>C1</math> contains the formula <math>B1 - B2</math>

then <math>C1</math> does not display <math>0</math> as would be expected,

but displays <math>-3.55271E-15</math> instead.