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

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

## 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 DOLLAR 1.125 FRACTION 32

### STEPS TO USE DOLLARFR

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.

• ## DECIMAL TO FRACTION CONVERSION,DOLLARFR IN EXCEL, FINANCIAL FUNCTION IN EXCEL

YOU MAY LIKE

LEARN

• EXCEL
• JAVASCRIPT
• MORE TO COME…

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com