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.
SYNTAX: DOLLARFR FUNCTION IN EXCEL
The Syntax for the function is
DOLLAR IN DECIMAL Value of dollar in decimal
FRACTION denominator of the fraction
FORMULA BEHIND THE FUNCTION
EXAMPLE:DOLLARFR IN EXCEL
DATA SAMPLE
| DECIMAL DOLLAR | 1.125 |
| FRACTION | 32 |
STEPS TO USE DOLLARFR
=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
- FUNCTION-DOLLARDE
- excel-conditonal formatting
- HOW TO ARRANGE, ALIGN AND ROTATE SHAPE OBJECTS IN EXCEL?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.