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

Question

Level 1

4 points

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

Answer 1

⚠️

Top-ranking reply

Level 7

26,613 points

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))

Reply

Answer 2

Level 1

22 points

Hello.

Hope this helps. There are a number of ways for this to work. This is the simplest and allows for easy growth.

Reply

Answer 3

Level 7

29,284 points

Another two ways:

=XLOOKUP(A1,{"cautious","balanced","growth"},{2%,5%,8%},"",0)

=IFS(A1="cautious",2%,A1="balanced",5%,A1="growth",8%,TRUE,"")

Reply

Quick Links