Software

Ask something
Discussion Locked

Excel 2000 problem

0 helpful
4 replies

by paul_gski

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

4 replies

by dklippert

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

This discussion is closed to new replies.