RMB in WPS on Windows FAQ

When using the RMB function, the most common questions are about formula errors, syntax prompts, and result checking. This FAQ covers 3 common questions and a short glossary.

FAQ

What should I do if the RMB function shows an error?

1. Check whether the formula starts with =.
2. Confirm that the function name, parentheses, and parameter separators are complete.
3. Review the syntax prompt to verify the number and format of parameters.
4. If you referenced a cell, make sure that cell contains a numeric amount that can be calculated.

How can I view the RMB function guide?

1. Select the target cell and enter =RMB(.
2. Review the syntax prompt that appears in the formula input area.
3. Confirm the parameter requirements in the prompt, then continue completing the formula.

How to use the RMB function in WPS on Windows if the result does not look right?

1. Check whether the referenced cell uses a numeric format instead of text-formatted numbers.
2. Confirm that the source amount itself is correct.
3. Edit the formula and press Enter again to recalculate the result.
4. If the sheet does not update right away, edit the formula again to trigger recalculation.

Glossary