Spread Formula Reference
FIXED
Formula Functions > Functions D to G > FIXED

This function rounds a number to the specified number of decimal places, formats the number in decimal format using a period and commas (if so specified), and returns the result as text.

Syntax

FIXED(num,digits,notcomma)

Arguments

This function has these arguments:

Argument Description
num Number to round and convert to text
digits [Optional] Number of decimal places; if omitted, uses two places
notcomma [Optional] Logical value whether not to use commas; if omitted or FALSE, returns with commas

Data Types

Accepts numeric data for first two arguments; accepts logical value for the third argument. Returns string (text) data.

Examples

FIXED(B3)

FIXED(R3C2,2,FALSE)

FIXED(4.2365,3)

Version Available

This function is available in product version 1.0 or later.

See Also

DOLLAR | Text Functions