Manuals/calci/FIXED

FIXED(number, decimals)

• where 'number' is the number to round, and

• 'decimals' is the number of digits after the decimal point.

FIXED() rounds a number to the specified number of decimals, and displays the result as text.

Description

FIXED(number, decimals)

FIXED(4567.786,1) returns 4567.8

• 'number' can be up to 15 bit number. If exceeded, Calci displays #ERROR message.

• If 'number' is negative, Calci rounds the number to left of the decimal point.

• Calci displays an #ERROR message, if number is non-numeric.

• 'decimals' is optional. If not mentioned, Calci assumes it to be '2'.

• The result is displayed as a text.

Examples

Function	Output
FIXED(35.56,1)	35.6
FIXED(99999.9,4)	99999.9000
FIXED(-45)	-45.00
FIXED(7866.44,-2)	7900

See Also

• ROUND
• ROUNDUP
• ROUNDDOWN
• TRUNC

References

• Types of Round functions