HELP WITH FORMULA
Posted by LUIGI on November 21, 2001 7:04 PM
HOW CAN I MANIPULATE THIS FORMULA TO ONLY DISPLAY A VALUE IF P23=GREATER THAN ZERO.
=IF(P23="","",(P23/2)<---THIS ONE IS GIVING ME NEGATIVE NUMBERS; P23 = -135 AND OFCOURSE IS GIVING ME -67.5 AS A RESULT.
THANK YOU!
Posted by Rod on November 21, 2001 7:12 PM
=IF(P23>0,P23/2,"")
Posted by Luigi on November 21, 2001 7:54 PM
How about if P23 has no value? Im getting "#VALUE". How can I get rid of that?
Thanks
Posted by Adam S. (NT) on November 21, 2001 8:04 PM
=IF(and(isnumber(P23)=true,P23>0)=true,P23/2,"")
nt
Posted by Rod on November 21, 2001 8:11 PM
=IF(AND(P23>0,NOT(ISERROR(VALUE(P23)))),P23/2,"")
Posted by Luigi on November 21, 2001 8:18 PM
Thanks! But how can I copy & paste on different cells without losing the format of the formula? $? I mean like P24 and so on....
Thank you.
Posted by Aladin Akyurek on November 21, 2001 10:47 PM
Or...
=IF(LEN(P23),IF(P23>0,P23/2,""),"")
Aladin
========
