FormatCurrency
Formats a specified string as a currency value. This function rounds the numbers up if the specified format uses fewer decimal points than the value itself and the remaining numbers total 5 or more. The function rounds the numbers down if the specified format uses fewer decimal points than the value itself and the remaining numbers total less than 5.
FormatCurrency(1, 2, 3, 4)
| Ordinal | Type | Description | |
|---|---|---|---|
| 1 | numeric | Required | Value to receive the specified formatting |
| 2 | string | Required | ISO culture code used to indicate the correct currency unit |
| 3 | numeric | The number of decimal places to include in the formatted value | |
| 4 | string | The currency symbol to use with the value. This value overrides the value specified by the culture code. |
This function rounds the numbers up if the specified format uses fewer decimal points than the value itself and the remaining numbers are 5 or greater. The function rounds the numbers down if the specified format uses fewer decimal points than the value itself and the remaining numbers total less than 5.
Example 1
System returns:
Example 2
System returns: