ReferenceFunctionsText Functions

FIXED

Formats a number as text with fixed decimal places.

Summary

Formats a number as text with fixed decimal places.

Remarks

Default decimal places is 2 when omitted.
Third argument controls comma grouping (TRUE disables commas).
Values are rounded to the requested decimal precision.
Numeric coercion failures return #VALUE!.

Examples

Fixed with commas

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

12,345.7

Fixed without commas

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

12345.7

FAQ

What does the third argument control?

Set it to TRUE to suppress thousands separators; FALSE keeps comma grouping.

Runtime metadata

Category

Text

Signature

FIXED(arg1: Number, arg2?: Number, arg3?: Logical)

Arity

min 1, max 3

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2optionaldefault

Number · Scalar · coercion NumberLenientText

arg3optionaldefault

Logical · Scalar · coercion Logical

Caps

PURE

Source

crates/formualizer-eval/src/builtins/text/extended.rs

FIND

FIND: Returns the 1-based position of one text string inside another.

LEFT

Returns the leftmost characters from a text value.

On this page

Summary Remarks Examples Related functions FAQ What does the third argument control?Runtime metadata