Hi everyone. Someone on here always has an answer for my question, so thanks
in advance.
I am running XP Pro SP2, and Office Pro 2003.
Column A is for quantity, and the quantity can be positive or negative.
Column H is for individual pricing, and Column I is for the price extension
(i.e. A*H).
Column I is blank unless there is a number to be displayed.
I have the following formula set up in I4 now:
=IF(A4>0,A4*H4,"")
which works OK if A4 is a positive number. What should the formula be so it
also works with a negative number? Rember that if A4 is blank, then I4 is
also blank.
In other words, I need an operator that will only work if A4 is not blank.
Thanks for your help.

Signature
Jim
msnews.microsoft.com - 05 Jul 2006 16:49 GMT
Try:
=IF(A4="","",A4*H4)
Is this too obvoius?
--
AP
> Hi everyone. Someone on here always has an answer for my question, so
> thanks
[quoted text clipped - 22 lines]
>
> Thanks for your help.
SteveW - 05 Jul 2006 16:51 GMT
try
=if(a4<>"",a4*h4,"")
Steve
> Hi everyone. Someone on here always has an answer for my question, so
> thanks
[quoted text clipped - 23 lines]
>
> Thanks for your help.
mattjenkins - 05 Jul 2006 16:53 GMT
how about
=IF(A4="","",A4*H4)
flummi - 05 Jul 2006 16:55 GMT
Hi,
=IF(ISNUMBER(A4);A4*H4);"")
Hans
Jim schrieb:
> Hi everyone. Someone on here always has an answer for my question, so thanks
> in advance.
[quoted text clipped - 19 lines]
>
> Thanks for your help.
Roger Govier - 06 Jul 2006 17:46 GMT
Hi Jim
In addition to the other replies you have received, you could just use
the formula without any IF() statement, and use
Tools>Options>General>untick Zero values
to prevent anything displayed if the result is 0

Signature
Regards
Roger Govier
> Hi everyone. Someone on here always has an answer for my question, so
> thanks
[quoted text clipped - 25 lines]
>
> Thanks for your help.
SteveW - 07 Jul 2006 17:09 GMT
> Hi Jim
>
> In addition to the other replies you have received, you could just use
> the formula without any IF() statement, and use
> Tools>Options>General>untick Zero values
> to prevent anything displayed if the result is 0
Too general, imo, but custom format of #;-#; changes 0 to nothing for
specific cells

Signature
Steve (3)