When using the ROMAN function in WPS, the most common questions involve argument errors, unexpected results, and batch use; this FAQ includes 3 common answers and a glossary.
FAQ
Why does the ROMAN function return #VALUE!?
- Check whether the argument is a valid number.
- Make sure the argument does not include extra spaces or text.
- If needed, clean the source data and enter the formula again.
Why is the ROMAN result different from what I expected?
- Check whether the referenced cell is correct.
- Make sure the source value is stored as a number instead of text.
- Review the
formargument and test the result again.
How to use the ROMAN function in multiple cells?
- Enter a correct ROMAN formula in the first cell.
- Select the cell and drag the fill handle across the target range.
- If you need fixed references, use
$where needed.
Glossary
| Term | Definition |
|---|---|
| ROMAN | A spreadsheet function that converts Arabic numbers to Roman numerals. |
| number | The required argument in the ROMAN function that specifies the number to convert. |
| form | An optional argument in the ROMAN function that controls the Roman numeral style. |