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

Is this too obvoius?

--
AP

"Jim" a écrit dans le message de news:
...
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(A40,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.
--
Jim