Thread: Correct Syntax
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
  
Posts: 1,316
Default Correct Syntax
=IF(OR(A1=1,A1=2),1,2)

--
Kevin Backmann


"TeeSee" wrote:

=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