Formula

[Ctrigg]

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 third question
listed above to work?

Thanks cedric

 

[Dan E]

C.

Same answer I posted in excel.programming

=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