Numbers Pop-Up Menu & Conditional Statements

Discussion in 'iWork Forum' started by jblaven, Jan 9, 2013.

  1. jblaven
    Offline

    jblaven iPF Noob

    Joined:
    Jan 9, 2013
    Messages:
    4
    Thanks Received:
    1
    Trophy Points:
    0
    Location:
    Georgia, USA
    Ratings:
    +1 / 0
    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
  2. jblaven
    Offline

    jblaven iPF Noob

    Joined:
    Jan 9, 2013
    Messages:
    4
    Thanks Received:
    1
    Trophy Points:
    0
    Location:
    Georgia, USA
    Ratings:
    +1 / 0
    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: Jan 9, 2013
  3. jblaven
    Offline

    jblaven iPF Noob

    Joined:
    Jan 9, 2013
    Messages:
    4
    Thanks Received:
    1
    Trophy Points:
    0
    Location:
    Georgia, USA
    Ratings:
    +1 / 0
    3rd post. :p

    Joe
  4. jblaven
    Offline

    jblaven iPF Noob

    Joined:
    Jan 9, 2013
    Messages:
    4
    Thanks Received:
    1
    Trophy Points:
    0
    Location:
    Georgia, USA
    Ratings:
    +1 / 0
    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
    • Like Like x 1
  5. twerppoet
    Online

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,190
    Thanks Received:
    1,943
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,145 / 1
    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.

Share This Page

Search tags for this page

apple numbers pop up menu

,
calendar pop up in iwork
,
conditional pop up numbers apple
,
ipad numbers hyperlink
,
item and cost pop-up menu in numbers
,
iwork numbers conditional pop up
,
mac numbers conditional pop-up
,
mac numbers pop-up list
,
multiple pop ups in numbers iworks
,
numbers countif with pop up menu
,
numbers dynamic popup
,
numbers if with pop ups
,

numbers pop up menu

,
numbers pop up menus
,
numbers popup menu iwork
,
numbers popupmenu
,
pop up calendar in iwork
,

pop up menu in numbers

,
pop-up calendar in iwork
,
popup menu limit on numbers for ipad