DOLLARFR function comes under the FINANCIAL FUNCTIONS category in Excel.
DOLLARFR function converts a dollar expressed in DECIMAL FORM to FRACTION FORM.
Its completely opposite to DOLLARDE function.(Click here to check DOLLARDE function)
PURPOSE OF DOLLARFR IN EXCEL
DOLLARFR function converts a dollar expressed in decimal to fraction form.
PREREQUISITES TO LEARN DOLLARFR
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 aboveWhat Excel does? How to use formula in Excel?
SYNTAX: DOLLARFR FUNCTION IN EXCEL
The Syntax for the function is
DOLLARFR(DOLLAR IN DECIMAL, FRACTION)
DOLLAR IN DECIMAL Value of dollar in decimal
FRACTION denominator of the fraction
FORMULA BEHIND THE FUNCTION
Its a simple conversion of decimal to fraction.
EXAMPLE:DOLLARFR IN EXCEL
STEPS TO USE DOLLARFR
The data is put in the cells from F6 TO F7.For the resultwe put the formula in F9 as
The result comes out to be $1.04 which is the dollar in fraction conversion from dollar in decimal.