Forum Discussion
IF comparison not returning correct value
Hi Could somebody pls help me see what I am doing wrong here. I want to compare the contents of cell O5 with the contents of Z40. If its the same return "balanced" if not return "error". The cont...
Without sample file it's hard to say something concrete. I may only guess that's so called floating point error. Try to compare ROUND(O4-O3, 5) and ROUND(Y40-X40, 5) or like.
Thank you Sergei. Yes it was a floating point error. Fixed now.