Menu
EXCEL DOLLAR FUNCTION
Excel DOLLAR Function Introduction
This Function translates a number to text and adds a currency symbol to it.
Description of Excel DOLLAR Function
Syntax:
=DOLLAR (number, [decimals])
Parameter list:
- number – the value to be converted.
- decimals – [optional] – the number of numbers to the right of the decimal point. The default value is 2.
If the decimal point is negative, the number will be rounded to the left.
Step By Step Guide of DOLLAR Function
Example :
Here when I gives =DOLLAR(A2, 2), it returns $1234.56 and so on.
Key Points
- The DOLLAR function uses currency number format to convert a number to text. $#,##0.00_);($#,##0.00) is the numeric format utilised.
- Because it can convert numbers to text in currency format as well as other number formats, the TEXT function provides a more versatile approach to achieve the same objective.
- The currency symbol used is determined by the computer’s language settings.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
