Converts a dollar price expressed as a decimal number into a dollar price expressed as a fraction.
תחביר
DOLLARFR(decimal_dollar, fraction)ארגומנטים
decimal_dollarחובה
The decimal number to be converted.
fractionחובה
The integer to use as the denominator of the 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.01Converts 1.125 to a fraction with a denominator of 8, resulting in 1 and 1/8.
Select the cell
Click on the cell where you want to display the fractional result.
Enter the formula
Type =DOLLARFR(decimal_dollar, fraction) and replace the arguments with your specific values.
Excel will truncate the fraction argument to an integer.