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,"")
 
Back
Top