Google Sheets-funktion

DOLLARFR

Converts a dollar price expressed as a decimal number into a dollar price expressed as a fraction.

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

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.

Argument

decimal_dollarobligatorisktThe decimal number to be converted.
fractionobligatorisktThe integer to use as the denominator of the fraction.

Exempel

=DOLLARFR(1.125, 8)

Resultat: 1.01

Converts 1.125 to a fraction with a denominator of 8, resulting in 1 and 1/8.

Vanliga frågor

What happens if the fraction argument is not an integer?

Excel will truncate the fraction argument to an integer.

Relaterade funktioner

DOLLARDE