DOLLARDE

Formulas / DOLLARDE
Convert dollar prices entered with a special notation to decimal numbers.
==DOLLARDE(fractional_dollar,fraction)
  • fractional_dollar - required argument that is the dollar component in special fractional notation
  • fraction - required argument that is the numerator in the fractional unit

Examples

  • =DOLLARDE(1.02,16)

    The DOLLARDE function can be used to convert fractions to decimals. For example, the formula can be used to convert 1.02 to a decimal. Since 1.02 is the same as 1 and 2/16, the function will return 1.125.

  • =DOLLARDE(1.125,16)

    The DOLLARDE function can also be used to convert decimals to fractions. For example, the formula can be used to convert 1.125 to a fraction. The function will return 1.02, which is the same as 1 and 2/16.

  • =DOLLARDE(1.08,16)

    The DOLLARDE function can also be used to convert currency fractions to decimals. For example, the formula if you have a currency fraction of $1 and 8/16, you can use to convert it to 1.5. This is because 1.08 is equal to $1.50 when expressed as 1 and 8/16.

  • =DOLLARDE(1.5,16)

    The DOLLARDE function can also be used to convert decimals to currency fractions. For example, the formula if you have a decimal of 1.5, you can use to convert it to a currency fraction. The function will return 1.08, which is the same as 1 and 8/16 or $1.50.


Summary

The DOLLARDE function is a useful tool for converting values pricing as a fraction or dollar to decimal format. It allows for easy and efficient calculations.

  • The DOLLARDE function converts a dollar price into a decimal number and the DOLLARFR function converts a decimal number into a dollar price.
  • Fractional_dollar and fraction arguments are used to specify the dollar component and the numerator in the fractional unit, respectively.

Frequently Asked Questions

What is the DOLLARDE function?
The DOLLARDE function is a mathematical formula that converts a dollar price expressed as an integer part and a fraction part into a dollar price expressed as a decimal number.
What is the dollar price?
The dollar price is a decimal number.
What is the fractional part of the dollar price?
The fractional part of the dollar price is divided by an integer that is specified.
Can the DOLLARDE function be used to convert a dollar price expressed as a fractional part and decimal number?
No, the DOLLARDE function is only used to convert a dollar price expressed as an integer part and fractional part.
What are some examples of how to use the DOLLARDE function?
The DOLLARDE function can be used to convert a dollar price expressed as an integer part and fractional part into a dollar price expressed as a decimal number. For example, if the integer part is 2 and the fractional part is 3/4, the DOLLARDE function can be used to convert this into 2.75.

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