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.
|