# DOLLARDE

DOLLARDE(fractional_dollar, fraction)

Returns the dollar fraction expressed as a decimal.

 fractional_dollar The decimal number you want converted. fraction The integer to use in the denominator of a fraction.

 REMARKS
 * This function converts a number expressed as a fraction to an equivalent decimal number.* 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 is useful when working with stock market quotes.* You can use the DOLLARFR function to return the dollar fraction expressed as a dollar decimal.* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A B 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,3) = 3.0 10 =DOLLARDE(1.6,0.9) = #DIV/0! 11 =DOLLARDE(5,0) = #DIV/0! 12 =DOLLARDE(5,-2) = #NUM!