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)

OrdinalTypeDescription
1numericRequiredValue to receive the specified formatting
2stringRequiredISO culture code used to indicate the correct currency unit
3numericThe number of decimal places to include in the formatted value
4stringThe 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: