Link to home
Start Free TrialLog in
Avatar of supportoranges
supportorangesFlag for United States of America

asked on

Excel Formula which tests a string

If contents of E3 = "Loss"
  value of G3 = -1 * contents of D3
If contents of E3 = "Win"
  value of G3 = ABS(D3)

I need to create a formula for cell G3 based on contents of E3 and D3 as described above.

Help is needed.
Avatar of Juan Ocasio
Juan Ocasio
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Here is another way to make sure that Win, WIN, win, Loss, LOSS, loss get identified:

Avatar of supportoranges


Thank you for this quick answer on the weekend.  It is really appreciated!
No problem!  Just reply to this chain if you need additional help or come across an outlier that isn't addressed here!