writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − + − − + − + − + − + − − − − − − − + − −
no edit summary
=FIXED(number, decimals)=
=FIXED(number, decimals)=
*where 'number' is the number to round, and
<div style="font-size:30px">'''FIXED (Number,DecPlaces) '''</div><br/>
*where 'Number' is the number to round, and
*'decimals' is the number of digits after the decimal point.
*'DecPlaces' is the number of digits after the decimal point.
**FIXED(), formats a number as text with a fixed number of decimals.
FIXED() rounds a number to the specified number of decimals, and displays the result as text.
== Description ==
== Description ==
FIXED(number, decimals)
FIXED (Number,DecPlaces)
*For Example, FIXED(4567.786,1) ''returns 4567.8''
For Example,
*'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.
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.
*Calci displays an #ERROR message, if number is non-numeric.
*'DecPlaces' is optional. If not mentioned, Calci assumes it to be '2'.
*'decimals' is optional. If not mentioned, Calci assumes it to be '2'.
*The result is displayed as a text.
*The result is displayed as a text.