CHAR in =IF function.

Hi,

How I do i use CHAR in a =IF formula? (or something similar)

e.g. =IF(A1=1,1,0)

i get either 1 or 0 depending on A1 value.

but if i want something like

e.g. =IF(CHAR(Y)=1,1,0)

i get 1 if it Y and 0 is it not Y.

Any idea?

Thanks!!

I believe he is asking how to make it check if there is text in the form of "Y" in cell A1.

That can be done by:

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

Originally Posted by bebo021999

CHAR returns Character
CODE returns number

Maybe you need CODE to compare with value?

Hi,

Is something like if i key in Y, it will be 1, if no then 0.

Originally Posted by ELeGault

Yea... CHAR(89) = Y or CHAR(121) = y Capital/Lower

What are you trying to do... if you want to say if it equals Y just put Y... = IF(A1="Y",1,0)

Char Table
Attachment 476368

And now that I think about it...are you trying to count if it contains a Y?

= Countifs(A1,"*Y*") The * asterisk symbol is a wildcard and says if anything comes before and after ignore it...count if everything between the two * exists...in this case Y... So count if it contains a Y

Really would help to know what you are thinking and or why you are doing this.

Hi,

Yeah, it worked with the "".

Thanks!!

Originally Posted by TheN

I believe he is asking how to make it check if there is text in the form of "Y" in cell A1.

That can be done by:

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

Hi,

Yes. Thank you!

Maybe like this ...

=--(A1="Y")