FormatCurrency

Overview

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.

Syntax

FormatCurrency(1, 2, 3, 4)

Function Properties

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.

Usage

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: