Conditional values

[Guest]

I am looking for a formula that would accomplish the following: the entering of an alpha value in a cell would trigger populating the adjacent cell with a numeric value, i.e. entering 'Y' in cell A1 would automatically populate cell B1 with '1' (I use column B as a counter).

Thank you.

 

[JE McGimpsey]

One way:

B1: =IF(A1="Y",1,0)

or, equivalently

B1: =--(A1="Y")

but depending on what you're doing, you can get a count of "Y"s in
Column A using

=COUNTIF(A:A,"Y")