
PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
CONTENTS
EXCEL FUNCTIONS-DOLLAR
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.
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.
OTHER WAYS TO REACH THIS ARTICLE
WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL
YOU MAY LIKE
- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.