Statement

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
 
J

J.E. McGimpsey

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