# Software

## General discussion

Locked

### Excel 2000 problem

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

Thread display: Collapse - | Expand +

Collapse -

### Excel 2000 problem

by 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

=ROUND(C2-C3,10)=B1

works

Collapse -

### Excel 2000 problem

by In reply to Excel 2000 problem

BTW try Tools>Options>Calculation Precision as displayed

Collapse -
by In reply to Excel 2000 problem

thank you, sorry took such a long time

Collapse -
by In reply to Excel 2000 problem

This question was closed by the author

## Related Discussions

• 0

#### ACTIVATING RESITRATION AFTER SELLER STOPS BUSINESS

dee1620814688 ·

• 1

pdyason ·

• 2

zamsam676 ·

• 5

#### What should be the ideal fan speed?

jimoravidar ·

• 2

Cmerrill1 ·