Money - script and chart function

The money function formats the expression numerically according to the string given as format-code. Decimal separator and thousands separator can be set as third and fourth parameters. If the parameters 2-4 are omitted, the number format that is set in the operating system will be used.

Syntax:  

Money(expression [ , format-code [ , decimal-sep [ , thousands-sep ] ] ])

 

Examples and results:

The examples below assume the following operating system settings:

	Default setting 1	Default setting 2
Money format	kr # ##0,00	$ #,##0.00

Example	Results	Setting 1	Setting 2
Money( A ) where A=35648	String:	kr 35 648,00	$ 35,648.00
	Number:	35648.00	35648.00
Money( A, '#,##0 ¥', '.' , ',' ) where A=3564800	String:	3,564,800 ¥	3,564,800 ¥
	Number:	3564800	3564800