These FAQ entries focus on 3 common areas when using the RMB function: formula entry, unexpected results, and batch use.
FAQ
What should I do if the RMB function does not return the expected result?
- Check whether the formula starts with
=. - Check whether the parentheses, parameters, and referenced cells are complete.
- Confirm that the referenced content is a numeric value that can be processed correctly.
What should I do if an error appears after I enter the RMB function?
- Check again that the function name is
RMB. - Review the parameters for invalid characters or extra spaces.
- Insert the function again from the Insert Function dialog to compare the format.
How can I use the RMB function in multiple cells at once?
- Enter the RMB function in the first target cell.
- After confirming the result is correct, drag the fill handle down or across to copy it.
- Check whether the cell references match your worksheet structure and adjust them if needed.
Glossary
| Term | Definition |
|---|---|
| RMB function | A built-in function in WPS Spreadsheet that converts numeric amounts into uppercase Chinese RMB text. |
| Insert Function | The function entry in WPS Spreadsheet that lets you search for a function and insert it through a parameter dialog. |
| Formula bar | The input area above the worksheet where you can enter or edit formulas such as =RMB(...). |