Thread: What is the syntax for nesting functions such as IF AND?
View Single Post
  #2   Report Post  
Oliver Ferns via OfficeKB.com
 
Posts: n/a
Default
Try (assuming the employee in question is named in cell A1)

=IF(OR(A1=Emp1,A1=Emp2,A1=Emp3),A1,"")

Hth,
Oli

--
Message posted via http://www.officekb.com
Reply With QuoteReply With Quote