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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Try (assuming the employee in question is named in cell A1)

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

Hth,
Oli
 
You must log in or register to reply here.

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

Creating Nested If Fuctions 3
Help with a nested IF statement containing AND and OR funtions 1
Nest IF function 6
nested what if statement 1
nested if function 5
nest functions in CELL function 1
IF INDEX and MATCH function together 7
Nested IF 2

Back
Top