Skip to main content
Write the formula, then read the value back.
values is the calculated value; text is the value as the cell shows it, with its number format.

Defined names

Errors

An unknown function or name gives #NAME?, as in Microsoft Excel. Read the value back to find it:
Do not write a number you computed in place of a formula. The file looks right, but it does not update when an input changes.