Expressions in Excel cells

When entering an expression in an Excel cell, use the appropriate method:

• Excel string

  Enter a single quote followed by the expression. This results in two single quotes in succession for expressions that begin with a PI point or PI AF attribute name.

  'abs('sinusoid')>1

  ''sinusoid'>1

  The single quote forces Excel to interpret the expression as a string.

  Use this method only if the expression contains no Excel functions or calculation operators (including those used for cell references in expressions).

• Excel formula

  Enter an equal sign followed by the expression within double quotes.

  =" abs('sinusoid') > 1"

  =" 'sinusoid' > 1"

  Use this method if the expression contains an Excel function or calculation operator, such as the ampersand used for cell references in expressions.

  This method can be used for any expression.