negative numbers

A

alexm999

I'd like to put in some formating or a formula that if cell A1 has the
word "Payout" then the numbers in cell D1 become a negative number...

How can this be dones?
 
K

Ken Wright

In D1,

=IF(A1="Payout",-(Original_Formula),Original_Formula)

unless of course it is possible that the original formula could have produced
negative results in the first place, in which case:-

=IF(A1="Payout",-ABS(Original_Formula),Original_Formula)
 
A

alexm999

Thanks!
Here's an add-on to the problem:

Same as above, but what if I have the word SEND instead of PAID? I
it's send, i'd like it the number to be positive
 
Top