Excel miscalculates over £62.99

May 15, 2011 at 03:59:03
Specs: Windows XP
corrupt file or corrupted excel?
I have a simple IF statement which works fine on other spreadsheets in the same book
=IF(K20=K21,"BALANCED","NOT BALANCED")
and suddenly it won't work on new sheets. Well, it will ALMOST work, since having made tedious tests for an hour, it works fine up to all values £62.99 and then fails for anything about £63.00. I have never run into a problem like this. could it be that excel itself is corrupted and should be reinstalled?

See More: Excel miscalculates over £62.99

Report •


#1
May 15, 2011 at 07:56:33
K20=K21

I take it that the two cells are the product of other calculations,
in that case make sure they are Exactly the same.
Open them out to 15 digits and see if there isn't a verrrry small difference.

62.99000 is not equal to 62.99005

You may need to ROUND your answers.


MIKE

http://www.skeptic.com/


Report •

#2
May 15, 2011 at 09:50:30
very much appreciated, I found a similar question an hour ago and the reply to that also suggested that rounding was the problem....and the solution. Grteful thanks, at least I don;t have to worry about Excel about to fall over.

Report •

#3
May 15, 2011 at 10:11:59
at least I don;t have to worry about Excel about to fall over.

Excel will do exactly what you tell it to do,
whether you like it or not.......

Glad I could help.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question