Numbers Pop-Up Menu & Conditional Statements
This is my first post and I wanted to introduce myself and say hi. Over the last few years, I've migrated to Apple products and have been very pleased. I've got my 1st generation iPad that has served me well over the last few years, and I'm looking to bring it back into service.
My problem is related to the Pop-Up Menus. I'm beating my head against a wall and not making much progress! :confused:
In Numbers, I'm using the Form tabs for data entry into the Sheet tab. I've got some Pop-Up Menus (for product options) that will adjust my final sell price accordingly.
Pop-Up menu contains the following:
Each color option would have a value associated with it, and would adjust the sell price as needed. I believe I'm having trouble because the options are strings and the functions I've been trying to use are expecting numbers or Boolean values. I guess I can't see the forest for the trees! :D
Any point in the right direction would be greatly appreciated!