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: