Hi. I have 4 dropdown and 4 checkboxes on a sheet. I need to create a formula or macro that will input information into cell "BK38" if certain criteria are met.
Dropdown example:
# OF TRIPS DRIVEN BEYOND A 50 MILE RADIUS
(if the person clicks a value >24 for the following #', the following messages should appear in cell "BK38")
51-100 "A srg will apply"
101-150 "Non-bind"
151-200 "Non-bind"
201+ "Not-eligible"
(The message order of priority is 201+, 151-200, 101-150, 51-100. For ex. If 25 is checked for 201+ and 25 is checked for 151-200, the message "Not-eligible" appears.)
--------------------------------------------------------------------------------
There are also 4 checkboxes.
Retail
Wholesale
Farm
For-Hire
If "For-Hire" is checked, the message "Non-binding" should appear. If farm is checked, "Revenue producing?" should appear.
Any assistance would be greatly appreciated.
Thanks
RJ
Dropdown example:
# OF TRIPS DRIVEN BEYOND A 50 MILE RADIUS
(if the person clicks a value >24 for the following #', the following messages should appear in cell "BK38")
51-100 "A srg will apply"
101-150 "Non-bind"
151-200 "Non-bind"
201+ "Not-eligible"
(The message order of priority is 201+, 151-200, 101-150, 51-100. For ex. If 25 is checked for 201+ and 25 is checked for 151-200, the message "Not-eligible" appears.)
--------------------------------------------------------------------------------
There are also 4 checkboxes.
Retail
Wholesale
Farm
For-Hire
If "For-Hire" is checked, the message "Non-binding" should appear. If farm is checked, "Revenue producing?" should appear.
Any assistance would be greatly appreciated.
Thanks
RJ