Cell Values???
Posted by Rob on June 28, 2001 2:28 PM
OK...I have a problem. I have a cell F2 with the following formula: =IF(H2=I2,"X",""). But, there is a problem. I2 is a currency cell which I manually input. But H2 is a formula which is:=G2*(1/3) . Even when H2 and I2 appear to be the same, the formula in F2 tests false, when it should be true. I have tried using the VALUE() function everywhere, but it doesn't seem to work. Is there another function I can use that will fix this? I appreciate the help :)
Posted by Aladin Akyurek on June 28, 2001 2:33 PM
Rob,
Try:
=IF(ROUND(H2,1)=ROUND(I2,1),"X","")
Aladin
Posted by Rob on June 28, 2001 4:19 PM
YES, thanks very much Aladin
Posted by Tracey on June 28, 2001 4:50 PM
Could be rounding try : =round(G2*(1/3),2)
