Category: Special function

This function converts value to text.

This is useful when you wish to validate the contents of a field or retrieve the text value of a field.

Return value type: Text

• Numbers are converted into their text representation.
• Boolean is converted into 'TRUE' and 'FALSE'.
• Empty cells are converted into empty strings (i.e. '').
• Text remains itself.
• Errors are converted into text with error message.
• This function never produces errors, only text.

astext( 'January' )  //Returns 'January '
astext( 125 )  //Returns '125'
astext( 2 + 2 = 4 )  //Returns 'TRUE'
astext( 2 + 2 = 5 )  //Returns 'FALSE'
astext( 1 / 0 )  //Returns 'Error: Division by zero'

• AsNumber(expression)