دالة Google Sheets

DOLLARDE

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

إنشاء صيغة بالذكاء الاصطناعي نفس الدالة في Excel

تعمل هذه الدالة في 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.

المعاملات

fractional_dollarمطلوبThe number expressed as a fraction.
fractionمطلوبThe integer to use in the denominator of the fraction.

أمثلة

=DOLLARDE(1.02, 16)

النتيجة: 1.125

Converts 1 and 2/16 into the decimal 1.125.

الأسئلة الشائعة

What happens if the fraction argument is not an integer?

Excel will truncate the fraction argument to an integer.

دوال ذات صلة

DOLLARFR