General discussion

Locked

Excel 2000 problem

By paul_gski ·
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

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel 2000 problem

by DKlippert 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

Collapse -

Excel 2000 problem

by DKlippert In reply to Excel 2000 problem

BTW try Tools>Options>Calculation Precision as displayed

Collapse -

by paul_gski In reply to Excel 2000 problem

thank you, sorry took such a long time

Collapse -

by paul_gski In reply to Excel 2000 problem

This question was closed by the author

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums