Converts a dollar price expressed as a fraction into a dollar price expressed as a decimal number.
이 함수는 Google Sheets에서도 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.