negative numbers

  • Thread starter Thread starter alexm999
  • Start date Start date
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?
 
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)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Red cell for negative numbers in Excel 1
Negative Numbers 8
Formula for If "" AND "" are true... 3
Custom Number Format for text 8
Displaying negatives with (brackets) 3
formatting negative numbers 1
EXCEL FORMULA 2
Help with positive and negative numbers 1

Back
Top