Difference between revisions of "Manuals/calci/DOLLAR"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''DOLLAR'''</font></font></font><font color="#4848...") |
(No difference)
|
Revision as of 21:34, 24 October 2013
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 |