What is wrong with this formula?
Yes!!!! Jerry, using the ABS worked! It never occurred to me after
years of working with Excel that when all cells were formatted as 2
decimal numbers there could still be a rounding error. Live and learn.
Thank you all ever so much.
Joan
"Bernard Liengme" wrote in message
...
Try =IF(ABS(D75-D76)<0.001,"Balanced","Error")
Like Jerry, I thnik you have an IEEE rounding issue here
best wishes
"Notbefore10" wrote in message
news:WqwBh.93895$Oa.50528@edtnps82...
I get the opposite effect when I apply this formula...
=IF(D75=D76,"Balanced","Error")
The answer is "Error", even though the amount is exactly the same in
D75 and D76.
If I reverse it I still get the wrong answer...
=IF(D75<D76,"Error","Balanced"
The answer is "Balanced"
I must be missing some very basic syntax knowledge. The cells D75 and
E76 are definitely the same number format.
Thanks for your help.
|