another IF function
i have this formula =IF('MDA Template'!F10=0,"n/a",I10*0.25), i want to have
my cell equal the result of I10x0.25 if F10 on the other sheet does not equal
zero. in this instance everything equals zero except F10 but it still says
'n/a'. what have i done wrong?
Thanks
|