Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Financial > DOLLARDE
 

DOLLARDE(fractional_dollar, fraction)

 
 Returns the dollar fraction expressed as a decimal.

 decimal_dollarThe decimal number you want converted.
 fractionThe integer to use in the denominator of a fraction.

 REMARKS
 
  		• This function is only available if you have the Analysis ToolPak add-in installed.
     
  		• If "fraction" is not an integer, it is truncated.
     
  		• If "fraction" = 0, then #DIV/0! is returned.
     
  		• If "fraction" < 0, then #NUM! is returned.
     
  		• This function converts a number expressed as a fraction to an equivalent decimal number.
     
  		• This function is useful when working with stock market quotes.

     EXAMPLES
     
     AB
    1=DOLLARDE(1.1,8) = 1.125=1+(1/8) = 1.125
    2=DOLLARDE(1.1,2) = 1.5=1+(1/2) = 1.5
    3=DOLLARDE(1.1,2) = 1.5=1+4/8 = 1.5
    4=DOLLARDE(1.25,5) = 1.5=1+(2.5/5) = 1.5
    5=DOLLARDE(5.08,4) = 5.2=5+(0.8/4) = 5.2
    6=DOLLARDE(5.24,4) = 5.6=5+(2.4/4) = 5.6
    7=DOLLARDE(100.24,4) = 100.6=100+(2.4/4) = 100.6
    8=DOLLARFR(DOLLARDE(101.2,4),4) = 101.2 
    9=DOLLARDE(1.6,0.9) = #DIV/0! 
    10=DOLLARDE(5,0) = #DIV/0! 
    11=DOLLARDE(5,-2) = #NUM! 
    		 
     Functions - D | Index - D | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top