IF in formula
 

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

IF in formula
 

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

IF in formula
 

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

IF in formula
 

If cells(1,1) = 1 or cells(1,1) = 2 or cells(1,1) = 3 then


end if

--
Regards,
Tom Ogilvy


"hme" wrote:


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