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

CONTENTS

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 above

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
DOLLAR CONVERSION FROM DECIMAL TO FRACTION
EXCEL DOLLARFR FUNCTION EXAMPLE

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.

OTHER WAYS TO REACH THIS ARTICLE

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

YOU MAY LIKE

LEARN

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

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: