Función de Google Sheets

DOLLARDE

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

Generar una fórmula con IA La misma función en Excel

Esta función funciona igual en Google Sheets que en Excel: misma sintaxis y mismos argumentos.

Sintaxis

DOLLARDE(fractional_dollar, fraction)

The DOLLARDE function is used to convert fractional pricing, such as securities prices, into decimal format. This is particularly useful for financial calculations where prices are traditionally quoted in fractions like 1/16 or 1/32.

Argumentos

fractional_dollarobligatorioThe number expressed as a fraction.
fractionobligatorioThe integer to use in the denominator of the fraction.

Ejemplos

=DOLLARDE(1.02, 16)

Resultado: 1.125

Converts 1 and 2/16 into the decimal 1.125.

Preguntas frecuentes

What happens if the fraction argument is not an integer?

Excel will truncate the fraction argument to an integer.

Funciones relacionadas

DOLLARFR