ExcelFlux

DOLLARDE function

Conversion — a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.

Financial

Where can you use it?

Budgeting, treasury and finance teams. When reviewing a scenario with cash flows, payment periods and rate assumptions, compare the input and output units in the example.

Scenario in the workbook

Check decimal quotes with a denominator of 100. With a denominator of 8, 02 would mean two eighths.

A worked example from the workbook

RowAB
6InputSecond input
72.02100
83.05100
94.07100
Record 1
=DOLLARDE(A7,B7)

Expected result2.02

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=DOLLARDE(1.02,8)
Turkish Excel · tr-TR
=LİRAON(1,02;8)

Expected result

1.25

Worked examples

Check decimal quotes with a denominator of 100. With a denominator of 8, 02 would mean two eighths.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 Input Second input
7 2.02 100
8 3.05 100
9 4.07 100
Case Formula Expected result
Record 1 =DOLLARDE(A7,B7) 2.02
Record 2 =DOLLARDE(A8,B8) 3.05
Record 3 =DOLLARDE(A9,B9) 4.07
Microsoft Excel reference