# 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.

## 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

=DOLLARFR(F6,F7)

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