What is the syntax for nesting functions such as IF AND?

L

Lane CC Laura

I'd like to select certain employees from a spreadsheet of all employees.
Nested functions seem to be the way to go, if this or this or this employee,
then print their name, otherwise leave blank. Any better ideas, or how can I
even get this one off the ground?
 
O

Oliver Ferns via OfficeKB.com

Try (assuming the employee in question is named in cell A1)

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

Hth,
Oli
 
Top