DOLLARFR

Formulas / DOLLARFR
Convert prices to a fractional notation.
==DOLLARFR(decimal_dollar,fraction)
  • decimal_dollar - required, numeric value for pricing as a normal decimal number
  • fraction - required, numeric value, denominator in the fractional unit

Examples

  • =DOLLARFR(1.125,16)

    The DOLLARFR function is useful for quickly converting numbers into fractions that have a denominator of 16 or 32. This example will convert 1.125 to 1 and 2/16.

  • =DOLLARFR(1.125, 32)

    The DOLLARFR function is useful for creating fractions with a denominator of 16 or 32. This example will convert 1.125 to 1 and 4/32.

  • =DOLLARFR(0.5, 16)

    The DOLLARFR function can be used to quickly and accurately convert decimal numbers into fractions. This example will convert 0.5 to 1/2.

  • =DOLLARFR(0.75, 16)

    The DOLLARFR function is helpful for converting decimal numbers into fractions with a denominator of 16 or 32. This example will convert 0.75 to 3/4.


Summary

The DOLLARFR function is used to convert decimal numbers to fractional dollar numbers by converting them to securities prices. It requires two arguments, decimal_dollar and fraction, to work correctly.

  • The DOLLARFR function converts prices from a regular decimal number format to a fractional notation. The DOLLARDE function performs the opposite conversion.
  • Both arguments for the DOLLARFR function must be numeric, and the value for the fraction argument must be greater than zero.

Frequently Asked Questions

What is the DOLLARFR function?
The DOLLARFR function is a Sourcetable function used to convert decimal numbers to fractional dollar numbers.
What is the purpose of the DOLLARFR function?
The DOLLARFR function is useful for converting securities prices into a fraction.
What are the advantages of using the DOLLARFR function?
  • The DOLLARFR function is easy to use and efficient.
  • It can be used to quickly convert decimal numbers to fractional dollar numbers.
  • It can be used to accurately calculate securities prices.
How do I use the DOLLARFR function?
The DOLLARFR function can be used by entering the decimal number in the function and the fractional dollar number it should return. For example: DOLLARFR(0.5, 2) will return 0.50.
What are some tips for using the DOLLARFR function?
  • Ensure that the decimal number is correctly entered in the function.
  • Be aware of the rounding rules when converting decimal numbers to fractional dollar numbers.
  • Check the results of the DOLLARFR function to make sure they are accurate.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV