# Software

## General discussion

• Creator
Topic
• #2134361

### Excel 2000 problem

Locked

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

• Author
Replies
• #3641248

### 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

=ROUND(C2-C3,10)=B1

works

• #3640682

### Excel 2000 problem

by dklippert ·

In reply to Excel 2000 problem

BTW try Tools>Options>Calculation Precision as displayed

• #2747360

### Reply To: Excel 2000 problem

by paul_gski ·

In reply to Excel 2000 problem

thank you, sorry took such a long time

• #2747359

### Reply To: Excel 2000 problem

by paul_gski ·

In reply to Excel 2000 problem

This question was closed by the author