Formula

  • Thread starter Thread starter Ctrigg
  • Start date Start date
C

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
 
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
 
Back
Top