Try this:
=IF(B1="W",YourWinCalculation,YourLossCalculation)

If B1 is blank, then if you want the cell result to remain blank:
=IF(B1,"","",IF(B1="W",YourWinCalculation,YourLoss Calculation))


If this is not what you want, please elaborate and possibly include your
other calculations.

HTH,
Paul


"CadensDad" wrote
in message ...

I am trying to create a formula using an if statemet. I would like to
put a W or an L in a certain cell. Of course for win or loss. I would
then like another cell to do a calculation for the W result and if L is
in the cell I would like to do a different calculation. I have the
calculations all figured out. I just can't get the if statement to
recognize a W or an L.. Thanks in advance. This is probably an easy
one, I am just overlooking something.


--
CadensDad
------------------------------------------------------------------------
CadensDad's Profile:
http://www.excelforum.com/member.php...o&userid=17469
View this thread: http://www.excelforum.com/showthread...hreadid=495776