PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

EXCEL FUNCTIONS-DOLLARFR

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.

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

The Syntax for the function is

DOLLARFR(DOLLAR IN DECIMAL, FRACTION)

DOLLAR IN DECIMAL Value of dollar in decimal

FRACTION denominator of the fraction

Its a simple conversion of decimal to fraction.

DECIMAL DOLLAR	1.125
FRACTION	32

The data is put in the cells from F6 TO F7.

For the result

we put the formula in F9 as

=DOLLARFR(F6,F7)

The result comes out to be $1.04 which is the dollar in fraction conversion from dollar in decimal.