Thread: IF function for multiple answers?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fastballfreddy
 
Posts: n/a
Default IF function for multiple answers?

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

Reply With QuoteReply With Quote