"0-0 Wai Wai ^-^" wrote in message
...

"Ron Coderre" ¦b¶l¥ó
¤¤¼¶¼g...
Try these:

For text in A1

1)If the first letter of the statement is "A" or number "2"
B1: =IF(OR(LEFT(A1,1)={"A","2"}),"YES","NO")

Brilliant!
I tried a similar function in vain.

=IF(LEFT(A1,1)={"A","2"},"YES","NO")

I tried to either press or not press "Ctrl+Shift+Enter", but I drew a
blank.
I still don't get why my function doesn't work.

Try
=IF(OR(LEFT(A1,1)="A",LEFT(A1,1)="2"),"YES","NO")
--
David Biddulph