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

--
CadensDa
-----------------------------------------------------------------------
CadensDad's Profile: http://www.excelforum.com/member.php...fo&userid=1746
View this thread: http://www.excelforum.com/showthread.php?threadid=49577

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

Try using th quotation marks around your letters in the IF statement
A1="L"


"CadensDad" wrote:


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

That is EXACTLY! what I was looking for. Thank You so much..

--
CadensDa
-----------------------------------------------------------------------
CadensDad's Profile: http://www.excelforum.com/member.php...fo&userid=1746
View this thread: http://www.excelforum.com/showthread.php?threadid=49577