Hello all,
I'm looking to set maximum values of a drop-down list based on the age profile of the relevant person. I wish to keep the drop-down list in place though.
The drop-down list consists of a list increasing in increments of 0.5% from 1% to 40%.
I wish to set the maximums as follows:
Up to age 30: 15%
Up to age 40: 20%
Up to age 50: 25%
Up to age 55: 30%
Up to age 60: 35%
Aged 60 and above: 40%
Is there any way I can enter a formula to allow this?
Many thanks.
P.S. I've attached a file for what I mean. Basically I want to restrict the entry value of cell B13 by whatever value is in C5. I would prefer to leave the drop-down list as is regardless, but to restrict the acceptance of certain values being entered based on C5.
Bookmarks