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...
Probably a rounding error.
Change the formula to
=IF(ROUND(O5,2)=ROUND(Z40,2),"balanced","error")
Thank you Hans. It worked. Sooo good to have this forum.