PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
CONTENTS
EXCEL FUNCTIONS-DOLLARDE
INTRODUCTION
DOLLARDE function comes under the FINANCIAL FUNCTIONS category in Excel.
DOLLARDE function converts a dollar expressed in fraction into decimal form.
PURPOSE OF DOLLARDE IN EXCEL
DOLLARDE function converts a dollar expressed in fraction into decimal form.
PREREQUISITES TO LEARN DOLLARDE
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: DOLLARDE FUNCTION IN EXCEL
The Syntax for the function is
DOLLAR IN FRACTION Value of dollar in fraction
FRACTION denominator of the fraction
e.g.
DOLLARDE(1.04,32) is read as 1 and 4/32
FORMULA BEHIND THE FUNCTION
EXAMPLE:DOLLARDE IN EXCEL
DATA SAMPLE
| FRACTIONAL DOLLAR | 1.04 |
| FRACTION | 32 |
STEPS TO USE DOLLARDE
=DOLLARDE(D5,D6)
The result comes out to be $1.125 which is the dollar in decimal conversion from dollar in fraction.
OTHER WAYS TO REACH THIS ARTICLE
WHAT IS EXCEL, HOW EXCEL WORKS, EXCEL FINANCIAL FUNCTIONS, HOW TO CONVERT DOLLAR FRACTION TO DECIMAL, DOLLARDE FUNCTION IN EXCEL
YOU MAY LIKE
- FUNCTION-DDB
- EXCEL-FUNCTIONS-VLOOKUP
- HOW TO USE FORMAT PAINTER IN EXCEL
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.