Convert text to number (weird problem)

[hedjr01]

This drives me crazy. It's so simple but it never seems to work right anymore.

Cell A1 always has either a Y or a N in it

I want Cell A2 to give me either a 1 for "Y" or 0 for "N" based on cell A1

So the simple formula should be:

IF(A1="Y",1,0) Right?

Sometimes it will do this (place a 1 in A2 when A1 is "Y") but if I test it by changing A1 to "N" then A2 does not change to 0.

The really odd thing is that I have this kind of formula elsewhere in older sheets in the workbook & they work fine.

What is going on here?

Thanks 4 your help

 

[Aladin Akyurek]

This drives me crazy. It's so simple but it never seems to work right anymore.

Cell A1 always has either a Y or a N in it

I want Cell A2 to give me either a 1 for "Y" or 0 for "N" based on cell A1

So the simple formula should be:

IF(A1="Y",1,0) Right?

Sometimes it will do this (place a 1 in A2 when A1 is "Y") but if I test it by changing A1 to "N" then A2 does not change to 0.

The really odd thing is that I have this kind of formula elsewhere in older sheets in the workbook & they work fine.

What is going on here?

Thanks 4 your help

Is the calculation set to automatic?

 

[hedjr01]

Aladin, you are a genius! Thanks!!!