What's new
Apple iPad Forum 🍎

Welcome to the Apple iPad Forum, your one stop source for all things iPad. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

Numbers Pop-Up Menu & Conditional Statements

jblaven

iPF Noob
Joined
Jan 9, 2013
Messages
4
Reaction score
1
Location
Georgia, USA
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! :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:
  • 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! :D

Any point in the right direction would be greatly appreciated!

Regards,

Joe
 
OP
J

jblaven

iPF Noob
Joined
Jan 9, 2013
Messages
4
Reaction score
1
Location
Georgia, USA
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
 
Last edited:
OP
J

jblaven

iPF Noob
Joined
Jan 9, 2013
Messages
4
Reaction score
1
Location
Georgia, USA
Alright!!! Post #4!!! :D

I wanted to follow up and let you know I resolved it. :thumbs: 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

iPad Fan
Joined
Jan 8, 2011
Messages
22,131
Reaction score
9,272
Location
Milton-Freewater, OR
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.
 

Most reactions

Latest posts

Top