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.
Helpful links for the prerequisites mentioned above What Excel does? How to use formula in Excel?
SYNTAX: DOLLARDE FUNCTION IN EXCEL
The Syntax for the function is
DOLLARDE(DOLLAR IN FRACTION, FRACTION)
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
Its a simple conversion of fraction to decimal.
EXAMPLE:DOLLARDE IN EXCEL
DATA SAMPLE
| FRACTIONAL DOLLAR | 1.04 |
| FRACTION | 32 |
STEPS TO USE DOLLARDE
The data is put in the cells from D5 TO D6.For the result we put the formula in D8 as
=DOLLARDE(D5,D6)
The result comes out to be $1.125 which is the dollar in decimal conversion from dollar in fraction.