Skip navigation

If Then statement to write text in cell

1267 Views 26 Replies Latest reply: Feb 6, 2013 2:48 PM by nandi RSS
  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Feb 4, 2013 9:00 PM (in response to nandi)

    Hi nandi,

     

    To insert a cell reference in the condition you must click the cell reference icon (shown at the right end of the box in the third rule definition in my earlier post, then cick the cell to be referenced.

     

    From the appearance of your first rule, I suspect you typed "B9" into the box. Numbers will interpret this as a literal value, not a cell reference.

     

    In th second rule, I suspect you have clicked B10 without first clicking the cell reference icon.

     

    To insert a cell reference, you must first click the cell reference icon, then click the cell to be referenced.

     

    Regards,

    Barry

  • Jerrold Green1 Level 7 Level 7 (28,270 points)
    Currently Being Moderated
    Feb 5, 2013 9:25 AM (in response to nandi)

    Nandi,

     

    There is a differece between "Equal to" which tests Values and "Text is" which tests Strings. It looks to me as though you are testing text strings, so you should be using the "Text is" comparison type.

     

    Jerry

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Feb 5, 2013 9:47 AM (in response to nandi)

    Nandi,

     

    The cell reference icon is circled in red below.

    Picture 2.png

    Click the icon, then click the cell that you want the rule to reference.

     

    Regards,

    Barry

  • Jerrold Green1 Level 7 Level 7 (28,270 points)
    Currently Being Moderated
    Feb 5, 2013 11:12 AM (in response to nandi)

    I was about to suggest that you must be using Numbers 08. It's time for you to upgrade.

     

    Jerry

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Feb 5, 2013 11:49 PM (in response to Jerrold Green1)

    There were many revisions made in th transition from numbers '08 to numbers '09. Apparently this was one of them.

     

    My '08 experience has been pretty minimal. Sorry that I missed this difference. Perhaps it would have been useful to provide the version information earlier in the conversation.

     

    Regards,

    Barry

  • Jerrold Green1 Level 7 Level 7 (28,270 points)
    Currently Being Moderated
    Feb 6, 2013 8:43 AM (in response to nandi)

    I see that you did put Numbers 08 in the Tags section, but I missed it. I'm glad to hear that you made the upgrade choice. You won't regret it.

     

    Jerry

1 2 Previous Next

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.