Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is this a bug in excel?
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. |