Help with IF formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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
Click to expand...

Too general, imo, but custom format of #;-#; changes 0 to nothing for
specific cells
 
Back
Top