DOLLARFR Function in Excel: Syntax, Examples and Free Practice
DOLLARFR is an Excel Financial function. Converts a dollar price expressed as a decimal into a fraction.
DOLLARFR syntax
Arguments
decimal_dollar: A dollar price expressed as a decimalfraction: The denominator to use for the fractional part
When to use DOLLARFR
DOLLARFR is used in loan, investment, or valuation models where precise financial math is required.
Practice DOLLARFR online, free
Open the live Excel-style spreadsheet and try DOLLARFR yourself. No Excel install or sign-up needed to start.
Practice DOLLARFR now →More Financial functions
Frequently asked questions
What does the DOLLARFR function do in Excel?
Converts a dollar price expressed as a decimal into a fraction.
What is the syntax of DOLLARFR in Excel?
The syntax is =DOLLARFR(decimal_dollar, fraction). decimal_dollar: A dollar price expressed as a decimal; fraction: The denominator to use for the fractional part.
Where can I practice DOLLARFR online for free?
Open the free live spreadsheet on Cellgrids and try DOLLARFR yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Financial functions · Excel case studies · Excel tutorials · Excel shortcuts