MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

========