hi, wrote an IF function and it seems to be giving the wrong results, and i need help troubleshooting.
i have these figures in the following cells:
A1: 220
B1: 220
C1: 0
D1: 0.83
E1: 175.5
F1: 7.1
basically i'm trying to verify that F1 is equal to a formula involving A1 to E1.
i had this function: =IF(((A1*D1)-((C1*E1)/B1)-E1)=F1,"correct","wrong")
and it keeps returning 'wrong', even though the results match.
sigh. i've been wrecking my brains over this for two days. any advice would be much appreciated!
-kenneth
Bookmarks