Thread: Help with IF statement
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Help with IF statement
"Sean.rogers" wrote:
Can you have multiple tests, in the test section of the if statement? For
example.
If (A2=1or2or5or25,True,False)

Try it like this: =IF(OR(A1={1,2,5,25}),"Y","N")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote