<div>
Here is another way to make sure that Win, WIN, win, Loss, LOSS, loss get identified:<br />
<br />
=IF(UPPER(E3)=&quot;LOSS&quot;,D3*-1<wbr />,IF(UPPER(<wbr />E3)=&quot;WIN&quot;,<wbr />ABS(D3),&quot;&quot;<wbr />))
</div>


Here is another way to make sure that Win, WIN, win, Loss, LOSS, loss get identified:

=IF(UPPER(E3)="LOSS",D3*-1,IF(UPPER(E3)="WIN",ABS(D3),""))

<div>
Thank you for this quick answer on the weekend. &nbsp;It is really appreciated!
</div>


Thank you for this quick answer on the weekend.  It is really appreciated!

<div>
No problem! &nbsp;Just reply to this chain if you need additional help or come across an outlier that isn't addressed here!<br />
<br />
jocasio
</div>


No problem!  Just reply to this chain if you need additional help or come across an outlier that isn't addressed here!

jocasio

<div>
<div class="content wysiwyg-content">
If contents of E3 = &quot;Loss&quot; <br />
&nbsp; value of G3 = -1 * contents of D3<br />
If contents of E3 = &quot;Win&quot;<br />
&nbsp; value of G3 = ABS(D3)<br />
<br />
I need to create a formula for cell G3 based on contents of E3 and D3 as described above.<br />
<br />
Help is needed.
</div>
</div>


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.

Excel Formula which tests a string

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.