C,

=IF(C5 = "W", 1, IF(C5 = "L", 0, ""))
enters a 1 for W a 2 for L and a "" for any other input

Dan E

"C.Trigg" wrote in message ...
Her is an example of the following question


W is entered into Cell C5

I read Cell C5 from C2

The question is what formula can do the following?

If Cell C5 is W then a 1 is entered into Cell C2.
If Cell C5 is L then a 0 is entered into Cell C2.
If Cell C5 is blank then how can I enter a blank into Cell
C2.

I have this so far.

if((C5 = "W"),1,0) How can I get the this question
listed above to work?