In VBA:
Select Case Cells(1, 1).Value
Case 1, 2, 3
MsgBox "1, 2 or 3"
Case Else
MsgBox "Something else"
End Select

HTH
--
AP

"Don Guillett" a écrit dans le message de news:
...
try
If Cells(1, 1) 0 And Cells(1, 1) < 4 Then MsgBox "Hi"

--
Don Guillett
SalesAid Software

"hme" wrote in message
...

Hi

How can I use IF formula when I mean as below:

IF Cell(1,1)=1,2,3 then

Do something

End if


--
hme
------------------------------------------------------------------------
hme's Profile:
http://www.excelforum.com/member.php...o&userid=15930
View this thread:
http://www.excelforum.com/showthread...hreadid=538025