I can't get my IF function right

[burp]

I want this:

I enter a number in cell A1. If the number ends in 1, nothing appears
in cell B1. If the number in A1 does not end in a 1 a message appears
in B2 that reads "You messed up - the number in cell A1 must end in a
1".

How can I do this?

 

[The Grinch]

in cell b1 type the following formula...

=if(right(A1,1)=1,"","you messed up"

 

[CLR]

=IF(RIGHT(A1,1)*1=1,"","you messed up-the number in cell A1 must end in a
1")

Vaya con Dios,
Chuck, CABGx3

 

[burp]

That works but why *1?

=IF(RIGHT(A1,1)*1=1,"","you messed up-the number in cell A1 must end in a1")

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

Glad it worked for you, thanks for the feedback.......

The "RIGHT" function turns the result into TEXT........the *1 turns it back
into a number, which it has to be to compare to "=1"........


Vaya con Dios,
Chuck, CABGx3

 

[burp]

Got'cha. Thanks for the help.

-----

Glad it worked for you, thanks for the feedback.......

The "RIGHT" function turns the result into TEXT........the *1 turns it back
into a number, which it has to be to compare to "=1"........


Vaya con Dios,
Chuck, CABGx3