Multiple Formulas in one cel?

[beldandy]

I have a multiple page document that is tracking my departments PTO. There is a single "Department" calendar and then individual calendars. On the Department calendar I need each day to list everyone who requested time off on that day, and skip the people who did not. Right now, I can make it list for one person, but how do I get it to do it for multiple people across many pages in a single cell. Here is what I currently have:

=IF(('employee1'!B8<1),,ʺEmployee1ʺ)

Now I need it somehow continue to say "AND IF(('Employee2!B8<1),,ʺEmployee2ʺ), etc. Is this even possible?

Many thanks!
Jennifer

[alansidman]

Look at Nesting If statements and the "And" statements

Here is a resource: http://www.techonthenet.com/excel/fo.../if_nested.php
and: http://www.techonthenet.com/excel/formulas/and.php

[beldandy]

Yes, but I need one cell to have multiple answers. Everthing I found resulted in one only.

[FDibbins]

Hi and welcome to the forum

Your requirement seems to be at odds. you want to combine
=IF(('employee1'!B8<1),,ʺEmployee1ʺ)
and IF(('Employee2!B8<1),,ʺEmployee2ʺ)

so, what result would you show if both employee1'!B8 AND employee2'!B8 were <1?

[beldandy]

I would like the cel to be able to check each of our 100 employees days and then list each one that is out that day. So the formula to pull for one employee would be
=IF(('employee1'!B8<1),,ʺEmployee1ʺ)

But then I want it to continue with employee 2, 3, etc. Is this possible?

Jen

[FDibbins]

i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[beldandy]

I cannot upload it without greatly changing the whole document as it contains material that cannot be shared. I ended up using a hidden sheet to calculate the formula I wanted. Thank you for trying. =)