Numbers Pop-Up Menu & Conditional Statements

[jblaven]

Hi All,

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!

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:

• None
• White
• Black
• Blue
• Red

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!

Any point in the right direction would be greatly appreciated!

Regards,

Joe

[Ads]

[jblaven]

I resolved it. See below for the link to the solution, this is only my 2nd post and I can't put links in my posts until after my 3rd post.

LOL, funny stuff.

Joe

[jblaven]

3rd post.

Joe

[jblaven]

Alright!!! Post #4!!!

I wanted to follow up and let you know I resolved it. The link below is a good tutorial (using the Mac version of Numbers). Keep in mind that when he types "Grocery" in the formula, he manually places quotes around the word. BUT on Numbers for iPad, don't manually add the quotes, just type Grocery. I guess Numbers for iPad sees the string "Grocery" as being different than the string Grocery.

I also created a separate table on the sheet for the individual color prices.

MacMost Now 557: If Statements and Checkboxes in iWork Numbers

Thanks,

Joe

[twerppoet]

Glad you got it figured out.

Thanks for following up with the solution.

Just guessing, because I have not looked at the video yet, but if you enter a string in a formula on the iPad (using the 'abc' key) it automatically adds the quotes in the formula. If you add your own quotes the the inner set of quote marks become part of the string.