Formula for text

[Andee Rubin]

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.

[Bill Finzer]

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

[Andee Rubin]

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