Help with IF formula

[Guest]

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.

 

[msnews.microsoft.com]

Try:
=IF(A4="","",A4*H4)

Is this too obvoius?

 

[SteveW]

try
=if(a4<>"",a4*h4,"")

Steve

 

[mattjenkins]

how about

=IF(A4="","",A4*H4)

 

[flummi]

Hi,

=IF(ISNUMBER(A4);A4*H4);"")

Hans

 

[Roger Govier]

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

 

[SteveW]

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