Manuals/calci/FIXED
Jump to navigation
Jump to search
FIXED(num,dec,nc)
where num is the number which is to round and convert to text and
dec is the number of digits to the right of the decimal point and
nc is a logical value
FIXED rounds a number to the specified number of decimals,and calculates the result as text.
FIXED
let’s see an example in (Column1 Row 1,Column2Row1)
I.e.=FIXED(C1R1,C2R1)
=FIXED(4567.786,1) is 4567.8
Syntax
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 4567.786 | 1 | 4567.8 | |
| Row2 | ||||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
