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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Index into a Table 1
VLOOKUP with WORKDAY? 4
IF function says too many nested 1
Lookup function 2
Nest IF function 6
VBA word change keys 0
Is a Nested Formula what I need? 1
scheduling 0

Top