What is the syntax for nesting functions such as IF AND?
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 -- Message posted via http://www.officekb.com |
All times are GMT +1. The time now is 02:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com