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

CONTENTS

EXCEL FUNCTIONS-DOLLARDE

INTRODUCTION

DOLLARDE function comes under the FINANCIAL FUNCTIONS category in Excel.

DOLLARDE function converts a dollar expressed in fraction into decimal form.

 

PURPOSE OF DOLLARDE IN EXCEL

DOLLARDE function converts a dollar expressed in fraction into decimal form.

 

PREREQUISITES TO LEARN DOLLARDE  

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: DOLLARDE FUNCTION IN EXCEL  

The Syntax for the function is

DOLLARDE(DOLLAR IN FRACTION, FRACTION)

DOLLAR IN FRACTION   Value of dollar in fraction

FRACTION   denominator of the fraction

e.g.

DOLLARDE(1.04,32) is read as 1 and 4/32

FORMULA BEHIND THE FUNCTION

Its a simple conversion of fraction to decimal.

EXAMPLE:DOLLARDE IN EXCEL

DATA SAMPLE

FRACTIONAL DOLLAR1.04
FRACTION32
DOLLARDE FUNCTION IN EXCEL
EXCEL DOLLARDE FUNCTION EXAMPLE

STEPS TO USE DOLLARDE

The data is put in the cells from D5 TO D6.
For the result
we put the formula in D8 as

=DOLLARDE(D5,D6)

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

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, EXCEL FINANCIAL FUNCTIONS, HOW TO CONVERT DOLLAR FRACTION TO DECIMAL, DOLLARDE 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: