Help with function / formula

[Cassie]

My mind is gone and I can't think of the correct formula.
in Col A I have Y or N but I want to have a formula in another cell AE to
put a 1 or 0 in another cell - a the moment I get #name?


Many thanks
Cassie

 

[Per Jessen]

Hi Cassie

Suppose you want Y to return 1 and N to return 0, use this

=If(A1="Y",1,if(A1="N",0,""))

Regards,
Per

 

[Jacob Skaria]

If you mean to say you need 1/0 in Col AE; try the below in cell AE2

=--(A2="Y")

If this post helps click Yes

 

[trip_to_tokyo]

Hi Cassie, try this:-

=IF(A1="y",1,0)

Putting a y in cell A1 will put a 1 in B1 (for example).

Putting a n in cell A1 will put a 0 in B1 (for example).

Please hit Yes if my posting has been helpful to you.

Thanks!

 

[David Biddulph]

If you're getting #name? you may want to tell us what formula you are using.