Manuals/calci/DOLLAR

From ZCubes Wiki
Revision as of 21:34, 24 October 2013 by MassBot1 (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
 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
Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/DOLLAR&oldid=370"