INTRODUCTION
DOLLAR function comes under the TEXT category in Excel.
DOLLAR FUNCTION converts a number to text format with a currency sign.
Dollar function is used when we need to convert a number to currency with a sign. Currency is used as per the language settings.
PURPOSE OF DOLLAR IN EXCEL
DOLLAR FUNCTION converts a number to text and applies a currency sign.
PREREQUISITES TO LEARN DOLLAR
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Some information about the financial terms is an advantage for the use of such formulas.
- Of course, Excel software.
Helpful links for the prerequisites mentioned above What Excel does? How to use formula in Excel?
SYNTAX: DOLLAR
The Syntax for the function is
=DOLLAR (NUMBER,DECIMAL POINTS)
NUMBER is value of the currency or number which you want to convert.
DECIMAL POINTS is the number of decimal points in the converted currencies.
The Syntax for the function is
=DOLLAR(NUMBER)
NUMBER is value of the currency or number which you want to convert.
DECIMAL POINTS , if skipped ,by default is taken as 2 by Excel.
EXAMPLE:DOLLAR IN EXCEL
DATA SAMPLE
Let us convert 100 into currency.
STEPS TO USE DOLLAR
The number is put in H10.
The output is to be created in I10. The function used to be
=DOLLAR(H10,2)
The output is rs.100 (the sign is for rupee) and after 100 two decimal places are set.
KNOWLEDGE BYTES
CHANGING THE CURRENCY SIGN
DOLLAR function converts any number into text format of the currency and places a currency sign at the starting.
The currency sign is set by the REGIONAL SETTINGS.
Go to LANGUAGE SETTINGS> REGION >REGIONAL FORMAT
e.g. IF SET AS US, THEN $ and so on.
