Formula for text

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • July 30, 2018 at 3:45 pm #636 Score: 0
    Andee Rubin
    Participant
    4 pts

    I’d like to write a formula to make every value for a particular variable a text (like “home”) – then I’m going to delete the formula and enter data in the next rows.  The purpose is to distinguish data we’ve downloaded from the Web from data students have collected.  I’m not sure how to write a formula to enter a text value.  The examples in the help docs are numerical.

    July 30, 2018 at 3:50 pm #637
    Bill Finzer
    Keymaster

    Hi Andee,

    Here’s one example:

    if(Age<20,”Young”,”Not Young”)

    Basically anywhere you might return a number, you can return a quoted string.

    Bill

    July 30, 2018 at 3:51 pm #638
    Andee Rubin
    Participant
    4 pts

    Never mind – I figured it out.  For others, the answer is:

     

    “TEXT”

     

    Important – no equals sign, but important to have the quotes, otherwise it’s interpreted as a variable.

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.