Thread: Correct Syntax
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Conan Kelly Conan Kelly is offline
external usenet poster
  
Posts: 419
Default Correct Syntax
TeeSee,

=IF(OR(A1=1,A1=2),1,2)

HTH,

Conan




"TeeSee" wrote in message
...
=IF(A1 = 1 #OR#2,1,2)

What is the correct way to write the OR part of the formula? Thanks


Reply With QuoteReply With Quote