Converts a dollar price expressed as a fraction into a dollar price expressed as a decimal number.
Эта функция в Google Таблицах работает так же, как в Excel — тот же синтаксис и аргументы.
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.
=DOLLARDE(1.02, 16)Результат: 1.125
Converts 1 and 2/16 into the decimal 1.125.
Excel will truncate the fraction argument to an integer.