Função do Google Sheets

DOLLARFR

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

Gerar uma fórmula com IA A mesma função no Excel

Esta função funciona no Google Sheets da mesma forma que no Excel — mesma sintaxe e argumentos.

Sintaxe

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.

Argumentos

decimal_dollarobrigatórioThe decimal number to be converted.
fractionobrigatórioThe integer to use as the denominator of the fraction.

Exemplos

=DOLLARFR(1.125, 8)

Resultado: 1.01

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

Perguntas frequentes

What happens if the fraction argument is not an integer?

Excel will truncate the fraction argument to an integer.

Funções relacionadas

DOLLARDE