Formula for differing "Pop Up Menu" selections that generates specified number

I'm looking for some help coming up with a formula to add some automation to my Numbers spreadsheet.


I have created a "Pop up Menu" in cell A1 with three potential selections of 'Cautious', 'Balanced' and 'Growth'.


I would like cell B1 to automatically fill with a specific percentage based on the selection in cell A1. The percentages are:


Cautious = 2.00%

Balanced = 5.00%

Growth = 8.00%


E.g. If Cautious is selected in the pop up menu in cell A1, I would like cell B1 to automatically fill with the percentage 2.00%.


Thank you in advance for any recommendations.

Posted on Aug 17, 2022 9:12 AM

Reply
Question marked as ⚠️ Top-ranking reply

Posted on Aug 18, 2022 6:33 AM

You can try something like this...


Create a pop-up menu list that includes the values:


Then you can use them like this:


B4=VALUE(RIGHT(A4, 5))


3 replies
Sort By: 

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Formula for differing "Pop Up Menu" selections that generates specified number

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.