VALUE in WPS on Windows FAQ

Q: What should I do if the VALUE function returns an error?

Check whether the formula starts with = . Check whether the parentheses and separators are entered correctly. Re-enter VALUE( and use the syntax guidance to correct the formula.

Q: How can I view the instructions for the VALUE function?

Select any editable cell. Type =VALUE( . Review the syntax guidance and parameter example shown by WPS.

When using the VALUE function in WPS, the most common issues fall into 3 groups: input errors, help lookup, and unexpected results; this section answers 3 common questions.

FAQ

What should I do if the VALUE function returns an error?

Check whether the formula starts with =.
Check whether the parentheses and separators are entered correctly.
Re-enter VALUE( and use the syntax guidance to correct the formula.

How can I view the instructions for the VALUE function?

Select any editable cell.
Type =VALUE(.
Review the syntax guidance and parameter example shown by WPS.

What should I do if the VALUE result is not correct?

Check whether the referenced content is recognizable as a text number.
Check whether the related cells contain an invalid reference or a circular reference.
Confirm the parameter again and let the spreadsheet recalculate the result.

Glossary

Term	Definition
VALUE function	A spreadsheet function that converts recognizable text into a numeric result.
Syntax guidance	The parameter help and example information shown while entering a function.
Cross-sheet reference	A way to reference cells from another worksheet in the current formula.