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
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][th]

G​

[/th][th]

H​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]Hours[/td][td][/td][td] formula C2 copied down[/td][td]Dropdown[/td][td][/td][td]Less[/td][td]More[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]

8​

[/td][td]Less[/td][td]=IF(A2<=8,"Less","More")[/td][td]B[/td][td][/td][td]A[/td][td]X[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

7.9​

[/td][td]Less[/td][td][/td][td]C[/td][td][/td][td]B[/td][td]Y[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

8.1​

[/td][td]More[/td][td][/td][td]Y[/td][td][/td][td]C[/td][td]Z[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

 

[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*