Help with IF formula
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.
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
|