I have the following formula in excel:

=IF((F157+G157)0,IF(B157<"#",(L156+G157-F157),L156),0)

The first two IFs evaluate to true so the result is basicaly L156+G157-F157
and the values are

(58,511.55 + 86.66 - <empty cell) [The 58k value is itself a result of
another formula like the above]

You would expect 58,598.21 but instead excel gives 58,598.210000000100000

Setting up three additional formulas that are just an equals on the two data
cells and the result gives the following:

58,511.55000000000000000
86.6600000000000000000

58,598.210000000100000000

Doing an 'Evaluate Formula' gives

IF(TRUE,IF(TRUE,(58511.55+86.66-F157),L156),0) and then

IF(TRUE,IF(TRUE,(58,598.2100000001-F157),L156),0)

AAARRRRGGGHHHHH!!!!! What is going on. I don't see how this can be anything
other than a bug. I have searched the MS site to look for a way of reporting
a bug but there doesn't seem to be one. Anyone got any ideas on this probelm
or know how to report a bug

Changing the 86.66 to .65 or .67 removes the 1 at the 10th decimal place. I
can work around it by using two rows in my sheet to make up the 86.66
transaction but if this keeps happening it is going to be very annoying.