Help with function / formula

  • Thread starter Thread starter Cassie
  • Start date Start date
C

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