Trouble with formula
Posted: Thu Feb 26, 2009 8:15 pm
I received an error message with this formula IF((Q10=0),0,(Q10*E10)-L10)
The error is Unknown Name Q10
If i use IF(sum(Q10=0),0,(Q10*E10)-L10) or IF((0+Q10=0),0,(Q10*E10)-L10) i don't received this error.
P.S The formula work fine in version 2.
I have a version 4.00.17
Thanks
The error is Unknown Name Q10
If i use IF(sum(Q10=0),0,(Q10*E10)-L10) or IF((0+Q10=0),0,(Q10*E10)-L10) i don't received this error.
P.S The formula work fine in version 2.
I have a version 4.00.17
Thanks