Statement

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



In article <vaCLa.40591$XE4.31645@fe05.atl2.webusenet.com>,
"Steve Cohen" <sacohen@bellsouth.net> wrote:

> 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
>
>
>