View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default ADD AN ITEM IN A FORMULA ONLY IF IT IS A NEGATIVE

Assume the number is in A1 and the number to which you're adding it is in B1.
In C1: =IF(A1<0,A1+B1,"")

where the set of double quotation double marks returns nothing.

Dave
--
Brevity is the soul of wit.


"tcazabon" wrote:

I would like to add an item in a formula only if it is a negative number.