ExcelFlux

DOLLARFR function

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

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

Compare fractional quotes at a denominator of 100. The notation can change with the denominator.

A worked example from the workbook

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

Expected result2.02

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=DOLLARFR(1.25,8)
Turkish Excel · tr-TR
=LİRAKES(1,25;8)

Expected result

1.02

Worked examples

Compare fractional quotes at a denominator of 100. The notation can change with the denominator.

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 =DOLLARFR(A7,B7) 2.02
Record 2 =DOLLARFR(A8,B8) 3.05
Record 3 =DOLLARFR(A9,B9) 4.07
Microsoft Excel reference