View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Help with IF formula

Hi Jim

In addition to the other replies you have received, you could just use
the formula without any IF() statement, and use
ToolsOptionsGeneraluntick Zero values
to prevent anything displayed if the result is 0

--
Regards

Roger Govier


"Jim" wrote in message
...
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