This FAQ covers 3 common issue types when using DOLLARFR, including error handling, unexpected results, and batch use, followed by a short glossary.
FAQ
Why does DOLLARFR show #VALUE! after I enter it?
- Check whether the parameters are valid numeric values and do not contain text, spaces, or invalid references.
- Make sure the formula uses the correct separator.
- If the data comes from another source, clean the content and enter the formula again.
Why is the DOLLARFR result different from what I expected?
- Check whether
decimal_dollarandfractionare entered correctly. - Make sure the cell format is not affecting how you read the result.
- If needed, reopen the function arguments dialog and review each value again.
How can I use DOLLARFR in multiple cells?
- Enter and confirm the DOLLARFR formula in the first cell.
- Select that cell and drag the fill handle at the lower-right corner across the target range.
- If a reference needs to stay fixed, use
$in the formula to lock the reference.
Glossary
| Term | Definition |
|---|---|
| DOLLARFR | A financial function in WPS Spreadsheets that converts a decimal dollar price to a fractional dollar price. |
| decimal_dollar | A numeric parameter in DOLLARFR that represents the decimal price to convert. |
| fraction | A numeric parameter in DOLLARFR that represents the denominator unit used for the fractional price. |