Thread: Correct Syntax
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Correct Syntax
One way:

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

Another:

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

In article
<51 ,
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