May 27 2022 10:33 AM
I wrote a formula for a drop down list based on the data of another cell (see below). What am I missing?
The drop down list should be the percentages if the data in another cell is a specific result.
=IFS(P4=“Meets Expectations”,“2.75,3.00,3.25”,P4=“Above Expectations”,“3.50,3.75,4.00”,P4=“Exceptional”, “4.25,4.50,4.75”,P4=“Needs Improvement”,“1.00,1.50,2.00”,P4=“Below Expectations”,“0.00”,P4=“New Hire”,“0.00”)
May 27 2022 11:22 AM
Solution
Attached is what I've called a cascading data validation (AKA drop down). See if you can follow the approach used there. It does depend on your having the most current version of Excel
May 27 2022 12:12 PM
May 29 2022 05:50 PM
As a follow up, I believe I have the formula correct, however the entire formula is showing in the drop down list. How do I fix the formula so only the actual list (percentages) show as options based on the rating in a different cell.
May 30 2022 12:42 AM
You should follow the example posted by Mathetes: using a range as source instead of a text string.
May 27 2022 11:22 AM
Solution
Attached is what I've called a cascading data validation (AKA drop down). See if you can follow the approach used there. It does depend on your having the most current version of Excel