This FAQ covers 3 common question types about DOLLARDE in WPS on Windows, including formula entry, argument setup, and result checking.
FAQ
What should I do if the DOLLARDE function returns an error?
- Check whether the formula starts with
=. - Make sure the function name is spelled
DOLLARDE. - Check whether the parentheses, commas, and number of arguments are complete.
- Press Enter again after correcting the formula.
What do the two DOLLARDE arguments mean?
- The first argument is the price expressed in fractional quotation form.
- The second argument is the denominator of the fraction, such as 8, 16, or 32.
- After you press Enter, the function returns a decimal result.
How to convert a fractional dollar price to a decimal value in WPS?
- Confirm that the original quotation is entered in fractional form.
- Check whether the denominator argument matches the quotation rule you are using.
- Review referenced cells for text, blanks, or invalid data.
- Correct the inputs and confirm the formula again.
Glossary
| Term | Definition |
|---|---|
| DOLLARDE | A financial function that converts a dollar price expressed as a fraction into a decimal value. |
| Denominator argument | The integer argument that defines the unit of the fraction, such as 16 for sixteenths. |
| Decimal value | The result shown in standard decimal form so it can be reused in later spreadsheet calculations. |