Hi everyone,

I may have discovered a way to solve my own question in a previous post
(http://www.excelforum.com/showthread.php?t=528208). I'm attempting to
use a nested IF formula as shown below:

=IF(B9=shifts!A1:A17,"8",IF(B9=shifts!A19:A35,"6", "OFF"))

B9 is a dropmenu of listed shifts (not available shifts) from another
worksheet within the same workbook, titled "shifts". From the
"shifts" worksheet, cells A1 through A17 are 8 hour shifts, while A19
through A35 are 6 hour shifts. I'm attempting to create a formula in
D9 (the hours column), which will automatically fill in 8, 6, or OFF,
depending upon the selection from the dropdown menu in B9.

I *almost* succeeded with a normal IF formula (where *8 was true &
everything else false). Then I realized nesting would probably be
better, since I didn't want any hours sitting in D during an employee's
day off :) Any help would be *VERY* much appreciated. Thanx in
advance...

Big M ;)


--
Big M
------------------------------------------------------------------------
Big M's Profile: http://www.excelforum.com/member.php...o&userid=32994
View this thread: http://www.excelforum.com/showthread...hreadid=528401