TRUE function

TRUE() TRUE()

Returns

Logical

TRUE.

Returns TRUE. As TRUE()TRUE() always returns TRUE, there is little reason to use this function — it is mainly provided for compatibility with spreadsheets.

Example

FORMATNUMBER(1234.56789, 2, 2, TRUE())FORMATNUMBER(1234,56789; 2; 2; TRUE())

Returns "1234.57", which is the number 1234.56789 formatted as a text string with two decimal places and no thousands separator. (The exact way a number is formatted as a text string varies with the language settings of the app.)