Dropdown menus dependent on another cell being <8.0 or >8.0

[Caitlin535]

Hello -
I've created a timesheet for my employees in Excel. I'd like there to be one particular dropdown menu that shows if the total hours for a day are less than 8.0, and another dropdown to show if the hours are more than 8.0. I know how to do dependent lists, but not how to make a list dependent on a numerical value . . .
Thanks!
Caitlin

 

[Yongle]

You did not say what happens to 8, so I assume it goes with Less than 8

Same trick as dependent dropdown, but use an extra column to convert values to text

Formula in C2 copied down
=IF(A2<=8,"Less","More")

Create 2 named ranges ("Less" and "More")
Less (range: F2:F4)
More (range: G2:G4)

Create dropdown in D2 (and copy down)
Allow: List
Source: =INDIRECT(B2)



Excel 2016 (Windows) 32 bit

	A​	B​	C​	D​	E​	F​	G​	H​
1​	Hours		formula C2 copied down	Dropdown		Less	More
2​	8​	Less	=IF(A2<=8,"Less","More")	B		A	X
3​	7.9​	Less		C		B	Y
4​	8.1​	More		Y		C	Z
5​

Sheet: Sheet1

 

[Yongle]

Previous post should read
Formula in B2 copied down
=IF(A2<=8,"Less","More")

 

[Caitlin535]

THANK YOU!! I'm embarrassed I didn't think of this myself *face palm*