Converts a dollar price expressed as a decimal number into a dollar price expressed as a fraction.
この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
DOLLARFR(decimal_dollar, fraction)The DOLLARFR function is used to convert decimal dollar values into fractional notation, which is commonly used for security prices. The fraction argument specifies the denominator to be used for the conversion.
=DOLLARFR(1.125, 8)結果: 1.01
Converts 1.125 to a fraction with a denominator of 8, resulting in 1 and 1/8.
Excel will truncate the fraction argument to an integer.