DOLLARFR

DOLLARFR(decimal_dollar, fraction)

Returns the dollar decimal expressed as a fraction.

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

REMARKS
* This function converts the decimal part of the "decimal_dollar" number into a fraction with the denominator being "fraction".
* 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 can be useful when working with stock market quotes.
* You can use the DOLLARDE function to return the dollar decimal expressed as a dollar fraction.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 AB
1=DOLLARFR(1.125,8) = 1.1=1+(1/8) = 1.125
2=DOLLARFR(1.5,2) = 1.1=1+(1/2) = 1.5
3=DOLLARFR(1.5,8) = 1.4=1+4/8 = 1.5
4=DOLLARFR(1.5,5) = 1.25=1+(2.5/5) = 1.5
5=DOLLARFR(5.2,4) = 5.08=5+(0.8/4) = 5.2
6=DOLLARFR(5.6,4) = 5.24=5+(2.4/4) = 5.6
7=DOLLARFR(100.6,4) = 100.24=100+(2.4/4) = 100.6
8=DOLLARDE(DOLLARFR(100.6,4),4) = 100.6 
9=DOLLARFR(1.6,3) = 1.2 
10=DOLLARFR(1.6,0.9) = #DIV/0! 
11=DOLLARFR(5,0) = #DIV/0! 
12=DOLLARFR(5,-2) = #NUM! 


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