Software·43,838 discussions

Excel 2000 problem

Locked

Get funny results when using Coniditonal formating. Here is the formula:
=sum(c2-c3)=b1
c2 = 73,896.74
c3 = 65,212.13
b1 = 8,684.61
the conditional formating tells me its false when it should be true

Topic

Excel 2000 problem

In reply to Excel 2000 problem

There’s an answer that makes machine sense, not human sense.
Excel uses floating point math. To Excel 73,896.74 – 65212.13 = 8684.61000000001.

(Type the Q number in the search box at support.microsoft.com)

Tutorial to Understand IEEE Floating-Point Errors

Q42980

Your numbers turn bad in the 10th place, so

=ROUND(C2-C3,10)=B1

works

Excel 2000 problem

In reply to Excel 2000 problem

BTW try Tools>Options>Calculation Precision as displayed

Reply To: Excel 2000 problem

In reply to Excel 2000 problem

thank you, sorry took such a long time

Reply To: Excel 2000 problem

In reply to Excel 2000 problem

This question was closed by the author

[Author]

Replies