fixed() Function

Function

fixed( number, decimals, no_commas )

Rounds the specified number off to a certain number of decimals and returns it as text, with optional commas.

Parameters

Keyword Type Description

number

Decimal

The number that the fixed function will prepare for display.

decimals

Number

The number of digits after the decimal that will be maintained. 2 by default.

no_commas

Boolean

Enter false to display commas, true to hide them. False by default.

Returns

Text

Examples

You can experiment with this function in the test box below.

Test Input

fixed(7.36819) returns 7.37

fixed(7.36819, 3) returns 7.368

fixed(7.36819, 4) returns 7.3682

fixed(7000.36819, 4) returns 7,000.3682

fixed(7000.36819, 4, true) returns 7000.3682

fixed(7000.36819, 4, 0) returns 7,000.3682

Open in Github Built: Fri, Nov 19, 2021 (11:59:11 AM)

On This Page

FEEDBACK