I’d still call myself a beginner with Numbers, but trying to delve further. I’d like a pop up menu item to trigger a number in a different cell.
For example: I’d like to select “Annually” from a pop up menu, and have “12” populate in another cell. Which I’ll hide and use to run an “Average” equation somewhere else. I’d appreciate your thoughts, thanks.
Hi ACrawl2,
you could use IFS, for every option in your Popup Menu you would need a section.
B2=IFS($A2="Annually",12,$A2="Quarterly",3,$A2="Monthly",1)
Based on your region the , or the ; will be used to separate the different sections of a formula. If you write one thousand as 1,000.00 then the , is used as your formula separator. If you write one thousand as 1.000,00 then the ; is used as your formula separator.
Hope this will solve your question, please let me know if this worked for you or if something in unclear.
Regards Ralf
Hi ACrawl2,
you could use IFS, for every option in your Popup Menu you would need a section.
B2=IFS($A2="Annually",12,$A2="Quarterly",3,$A2="Monthly",1)
Based on your region the , or the ; will be used to separate the different sections of a formula. If you write one thousand as 1,000.00 then the , is used as your formula separator. If you write one thousand as 1.000,00 then the ; is used as your formula separator.
Hope this will solve your question, please let me know if this worked for you or if something in unclear.
Regards Ralf
If you're running the latest Numbers then you have an even easier and shorter function, SWITCH.
=SWITCH(A2,"Annually",12,"Quarterly",3,"monthly",1)
Note that explanations of functions with examples are easily accessible via Help > Formulas and Functions Help in your menu.
SG
Or you could use XLOOKUP
B2=XLOOKUP($A2,{"Annually";"Quarterly";"Monthly"},{12;3;1},1,0,1)
Thank you Ralf-F. The IFS formula worked nicely. The screenshot helped me wrap my mind around the function. Thanks for the links as well. Bookmarked for sure.
Oh wow. Thanks, SGIII, for the update. I’ll give this a shot as well.
Pop up Menu to trigger a value
