Can an IF function in one cell cause an action in a different cell?

Discussion in 'iPad General Discussions' started by larrycruzen, Apr 9, 2014.

  1. larrycruzen
    Offline

    larrycruzen iPF Novice

    Joined:
    Sep 17, 2012
    Messages:
    50
    Thanks Received:
    3
    Trophy Points:
    8
    Location:
    Tennessee
    Ratings:
    +4 / 0
    Is it possible to write an If function that causes an action in a different cell?

    In words: IF cell A2="yes",then cell A3=7,else cell A4=9

    I tried (in cell A3): IF(A2="yes"',7,A4=9) Doesn't work.

    Larry Cruzen
  2. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,843
    Thanks Received:
    2,233
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,664 / 1
    It can't be done. It would be really cool if you could, almost macro like, but you can't.

    I'm assuming you are talking about Numbers, and on the iPad.
  3. Blue92
    Offline

    Blue92 iPad Fan

    Joined:
    Mar 4, 2012
    Messages:
    167
    Thanks Received:
    14
    Trophy Points:
    18
    Location:
    Central Ohio
    Ratings:
    +15 / 0
    You actually have to work in the other direction:

    In words: IF cell A2="yes",then cell A3=7,else cell A4=9

    Cell A2 would contain the value and
    Cell A3 would be: @IF(A2="yes",7,"")
    Cell A4 would be: @IF(A2<>"yes",9,"")
    • Like Like x 1
  4. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,843
    Thanks Received:
    2,233
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,664 / 1
    Yep, that's the best way to get the described result. It bypasses the need to target a cell. I like that you included the null value as the else. Much cleaner than leaving it up to chance. In this case it seems to want to leave a FALSE value by default.

    @Larry, in case you don't know how to get the null value. Use the "abc" key to get the text entry field then tap Done without entering any text. This shows up in the formula as "". Entering a space looks the same in the cell, but has a different affect on computations and value testing.


    Also, in Numbers you won't find a <> key, and using individual < and > keys won't give the desired 'not equal to' result. Instead use the ≠ key.
    Last edited: Apr 9, 2014
  5. larrycruzen
    Offline

    larrycruzen iPF Novice

    Joined:
    Sep 17, 2012
    Messages:
    50
    Thanks Received:
    3
    Trophy Points:
    8
    Location:
    Tennessee
    Ratings:
    +4 / 0
    Thanks for the replies. Appreciate you pointing out the subtleties of the null value. Of course, I would have figgered that out by myself in about 2 years.

    Yep, I'm using NUMBERS on my IPAD. RE-downloaded both NUMBERS & PAGES. Both still lock up my IPAD most of the time when I try to delete a document. Wife's IPAD AIR works more consistently, but she won't trade.

    Larry Cruzen
  6. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,843
    Thanks Received:
    2,233
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,664 / 1
    :), some spouses can be so unreasonable. :)
  7. Blue92
    Offline

    Blue92 iPad Fan

    Joined:
    Mar 4, 2012
    Messages:
    167
    Thanks Received:
    14
    Trophy Points:
    18
    Location:
    Central Ohio
    Ratings:
    +15 / 0
    I cheated and used Excel on my desktop......
  8. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,843
    Thanks Received:
    2,233
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,664 / 1
    I figured it was something like that. Fortunately Numbers will translate most of the minor syntax differences when importing/exporting; as long as the formula is actually possible. There are some really crazy, complex, and indirect functions in Excel that Numbers does not have.
  9. Alex.Alqarni
    Offline

    Alex.Alqarni iPF Noob

    Joined:
    Apr 11, 2014
    Messages:
    3
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    Good to know thanks guys


    Sent from my iPhone using Tapatalk

Share This Page