This FAQ covers 3 common question types about the BASE function: input errors, syntax guidance, and incorrect results.
FAQ
What should I do if the BASE function shows an error?
- Check whether the formula starts with
=. - Confirm that parentheses, commas, and the number of arguments are correct.
- Review the syntax prompt that appears after entering
BASE(and correct the formula as needed.
How can I view the argument guidance for the BASE function?
- Select the target cell and type
=. - Enter
BASE(. - Review the syntax prompt that appears and continue entering the arguments.
What should I do if the BASE function result is incorrect?
- Check whether the referenced cell values meet the function's argument requirements.
- Confirm that there are no incorrect references or nested formula issues.
- Edit the arguments and press Enter again to see whether the result updates.
Glossary
| Term | Definition |
|---|---|
| BASE | A function in WPS Sheets that converts a number into text in a specified radix. |
| Formula bar | The area used to enter and edit formulas. |
| Syntax prompt | On-screen guidance that shows argument requirements while you enter a function. |