Evaluate a Text Calculation in WPS Office Spreadsheets and Return the Result
Question details
The user wants WPS Office Spreadsheets to calculate an expression stored as text in one cell, such as C2 containing 3*3, and display the result in another cell.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A spreadsheet cell contains a calculation stored as text, and the user needs the calculated result in a separate cell without manually retyping the expression.
- Observed behavior
- Spreadsheet applications treat a cell value without an equals sign as text, so 3*3 is not automatically evaluated as a formula unless it is entered directly or referenced through a legacy EVALUATE defined name.
Make sure the text calculation is in a single cell (for example, C2 contains 3*3 without an equals sign) and identify the cell where the result should appear (for example, D2).
Enter the calculation directly in the result cell
Use this for one-time or simple calculations when the expression is already known; it avoids named formulas entirely.
If you do not need to read the expression from another cell, typing the formula directly is the simplest and most reliable method.
Click the cell where you want the result, such as D2.
Type =3*3 and press Enter. WPS Office Spreadsheets calculates the expression and displays 9.
Create a defined name with EVALUATE to calculate text from a cell
Use this when the expression is stored as text in another cell and you want the result to update automatically.
Evaluate Text Calculations in WPS Office Spreadsheets
WPS Office Spreadsheets lets you evaluate a cell containing a text calculation by entering the formula directly or by creating a defined name with the legacy EVALUATE function, so results update automatically.
- 1. Open your workbook: Open the workbook that contains the text calculation in WPS Office Spreadsheets.
- 2. Choose a method: For a simple one-time result, select the result cell and enter =3*3 directly. For dynamic text evaluation, go to the Formulas tab and open Name Manager.
- 3. Create an Eval defined name: Create a defined name named Eval with =EVALUATE(C2) in the Refers to box, replacing C2 with your source cell.
- 4. Return the result: Enter =Eval in the result cell and press Enter to display the calculated value.
Frequently Asked Questions
Why does WPS Office or Excel not evaluate 3*3 when it is stored as text?
Spreadsheet applications treat a cell value that does not begin with = as text, so expressions like 3*3 are not calculated automatically. Enter the expression as =3*3 or use a defined name with EVALUATE to evaluate a text cell.
Can I use EVALUATE in WPS Office Spreadsheets?
Yes, in desktop versions you can use it through a defined name. Go to the Formulas tab, open Name Manager, create a name such as Eval, and set the Refers to box to =EVALUATE(C2). Then enter =Eval in the result cell.
How do I make the result update when the text expression changes?
Use a defined name such as Eval with =EVALUATE(C2) and enter =Eval in a result cell. When you edit the text in C2, the result recalculates automatically.
What if my text calculation is in a different cell, such as A1?
In the defined name, change the reference from C2 to your source cell, for example =EVALUATE(A1). Then type =Eval in the cell where you want the result.
Is typing =3*3 directly better than using EVALUATE?
For a one-off simple calculation, typing =3*3 directly is simpler and more compatible. For a dynamic text expression that may change, a defined name with EVALUATE is more convenient.
