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

On 15 Sep., 15:52, Cassie wrote:
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

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
---------------
Jacob Skaria


"Cassie" wrote:

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, 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!






"Cassie" wrote:

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

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

"Cassie" wrote in message
...
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