Variable Values With Drop Down Lists!!!

[cecistar]

All my excel knowledge is self taught (thanks youtube,mr. excel and the public library) and I am by no means an expert so bear with me.

Here's the basic of what I am trying to crate:
I need to calulate a number of days worked based on a certain amount of hours allowed and a timebase. For example: If I am on a 3/4 time base then I work 6 hours a day. If I am allowed to work 64 hours in the month, then that means I will work 10.666 days in the month. (64 hours allowed/6 hour work day= 10.666 days of work)Whereas, if I am on a Full Time Time base it means I work an 8 hours day and will have 8 work days. (64 hours allowed/8 hour work day = 8 days of work). As you can see, as the time base changes, so do the number of days you work.

There are 15 different timebases and herein lies my problem.
On this SS I have created a drop down list with 15 different values.
I need one formula which will change depending on the value selected from the drop down list. I was using a huge IF condition, but then I found out I can only nest for 7 levels so I'm still 8 levels short. K44 is the cell with the drop down list of the 15 different time bases.

Here's the huge nest I created.

IF(K44="Full Time",E42/8,
IF(K44="9/10 (7.20)",E42/7.2,
IF(K44="7/10 (5.60)",E42/5.6,
IF(K44="3/10 (2.40)",E42/2.4,
IF(K44="1/10 (0.80)",E42/.80,
IF(K44="7/8 (7.00)",E42/7,
IF(K44="3/4 (6.00)",E42/6,
IF(K44="5/8 (5.00)",E42/5,
IF(K44="1/2 (4.00)",E42/4,
IF(K44="3/8 (3.00)",E42/3,
IF(K44="1/4 (2.00)",E42/2,
IF(K44="1/8 (1.00)",E42/1,
IF(K44="4/5 (6.40)",E42/6.40,
IF(K44="3/5 (4.80)",E42/4.80,
IF(K44="2/5 (3.20)",E42/3.20,
IF(K44="1/5 (1.60)",E42/1.60,0))))))))))))))))
It is important that the answer only be in one cell.
If its possible let me know.

Thanks!

 

[Steve=True]

You should check out this site:

http://blog.contextures.com/archives/2011/07/25/no-duplicates-in-multiple-selection-excel-drop-down/

She has other posts on similar topics, so if this doesn't work, look/search for other articles in the last couple of months.

Steve=True
www.exceldashboardtemplates.com

 

[circledchicken]

Hello,

If I understand the question correctly, the formula below should be equivalent to your nested If formula:

=IF(K44="Full Time",E42/8,E42/(LEFT(RIGHT(K44,5),4)))

 

[mikerickson]

With that many options, its common to use a VLOOKUP chart

FullTime 8
9/10(7.20) 7.2
7/10(5.6) 5.6
...

which would turn your formula into
=E42 / VLOOKUP(K44, table_range, 2, False)

Where table_range is the address of the two column table.