Statement

  • Thread starter Thread starter Steve Cohen
  • Start date Start date
S

Steve Cohen

I'm lookg for a statement or function that will take the dollar amount of
cell A6 and make it positive if cell D6 equals "Win", and negative if D6
equals "Loss".

Thank you in advance.

Steve
 
One way:

=IF(D6="Win",ABS(A6), IF(D6="Loss",-ABS(A6),"")

which will return a null string if D6 is neither Win nor Loss.


If the dollar amount in A6 will always be positive, this can be
simplified to:

=IF(D6="Win",A6, IF(D6="Loss",-A6,"")
 

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

How to keep formula and be able to input value in cell? 0
macro to check if cells have values in them...then 4
A macro to check range and then check another range if falset-then 2
Take an average of data where lookup in array is needed 3
Can this be done? 4
Formula,Function, or VBA 1
Excel change formula after a certain amount 4
excel rounding error? 4

Back
Top