How to use the DOLLAR Function in Excel
Description
The DOLLAR Function is categorized as Text Function in Excel. This function converts a number to text using currency format and the currency symbol depends on your local language setting, by default it is $ sign. The format used is $#,##0.00_);($#,##0.00). It also rounds the number to specified number of decimal place.
The DOLLAR function takes two argument one is number and other is decimals. Both the argument can be any cell reference or a number. It can also be used as a part of a formula.
The same thing can be done with TEXT function.
Syntax
The syntax of DOLLAR function is =DOLLAR(number,[decimals])
Argument or Parameter
text (Required)- can be a cell reference or a number which we want to convert.
decimals (Optional) - is ta cell reference or a number to round off the decimal place of the number.
- If decimals is omitted, by default it takes 2.
- If the decimals value is negative then the number is rounded to the left of the decimal place.
- If the decimals value is positive then the number is rounded to the right of the decimal place.
Returns
The DOLLAR function converts a number to currency format of system's local language and round off the to specified decimal place.
Example
Example-1
In the example, in column A we have provided with some numbers to convert it text in dollar format and in column B some numbers to round off the numbers. In cell C3 type =DOLLAR(A3,B3) and press Enter. We can see the result as shown in the image below. Now drag the formula till the last cell and view the result of all the numbers. You can the currency format is added and and number are rounded off according to the value specified in column B.
Example-2
In this example we have three data, Date, Product and Net Sales. Now we want to convert it to "Total Sales of HDD Rs.55250.00". So will understand it step by step.
In Cell D3 type ="Total Sales for "&B3&" "&C3 and press Enter. You will get result as "Total Sales for HDD 55250". Its simple.
Now in E3, we will convert it TEXT function
="Total Sales for "&B3&" "&TEXT(C3,"Rs.##,###.00") , so it returns "Total Sales for HDD Rs.55,250.00"
Same thing can be done more easily by DOLLAR function
="Total Sales for "&B3&" "&DOLLAR(C3,2), and it returns "Total Sales for HDD Rs.55,250.00".
Notes
- If decimals is omitted, by default it takes 2.
- Decimals can be 0, a negative number or positive number.
- We can use TEXT function to do the same job.
********************************* ~:Support Our Work Financially:~ *********************************
Project File Type: Free
If you think this tutorial helps you to solve your problem and add value to your work, Buy me a Coffee..
************************************************************************************************
|
||||
CHAR |
CLEAN |
CONCATENATE |
||
DOLLAR |
EXACT |
FIND |
FIXED |
LEFT |
LEN |
MID |
NUMBERVALUE |
||
REPLACE |
REPT |
RIGHT |
SEARCH |
SUBSTITUTE |
T |
TEXT |
TRIM |
UNICHAR |
UNICODE |
UPPER |
VALUE |
|
|
|
0 Comments