=IF(AND(Carlos!B3=8,Jim!B3=8),"Carlos and Jim","")
you can use multiple if statements they go like this:
=IF(Condition,what to do if True,IF(Condition,What to do if True,What to do
if False))
Have a look at the Excel Help under function AND
Hope this helps
--
"Twice and twice shall he be marked,
twice to live and twice to die.
Once the heron, to set his path.
Twice the heron, to name him true."
"fastballfreddy" wrote:
In Sheets 1-8 I have calendars for different people w/ 8 on days they
have off
In Sheet9 I have in Column A days 1-31
In column B I have: =IF(Carlos!B3=8,"Carlos")
My problem/question is can I use the IF function to get multiple
answers? If Carlos and Jim both have the same day off, what function
would I use?
Thanks,
--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=537551