Manuals/calci/DOLLAR
DOLLAR(num,dec)
where num is a number, and dec is the number of digits to the right of the decimal point.
It converts a number to text using currency format, with the decimals rounded to the specified place.
DOLLAR
Let’s see an example in (Column1 Row 1,Column1Row2)
I.e.=DOLLAR(C1R1,C1R2)
=DOLLAR(4567.894,2) is $4,567.89
Syntax
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 4567.894 | 2 | ||
| Row2 | $4,567.89 | |||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
