DOLLARDE

DOLLARDE(fractional_dollar, fraction)

Returns the dollar fraction expressed as a decimal.

fractional_dollarThe decimal number you want converted.
fractionThe 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

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


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top