Converts a dollar price expressed as a decimal number into a dollar price expressed as a fraction.
이 함수는 Google Sheets에서도 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.