EXCEL FUNCTIONS-DOLLARFR

INTRODUCTION

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

DATA SAMPLE

DECIMAL DOLLAR1.125
FRACTION32
EXCEL DOLLARFR FUNCTION EXAMPLE

STEPS TO USE DOLLARFR

The data is put in the cells from F6 TO F7.For the resultwe 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.