The Evaluate function in Excel2003 is used to sum the sum in the document, which can only be entered in insert → name → definition. Enter related syntax: "EVALUATE (Formula_text) Formula_text" is an expression that requires a value in literal form.
Note: using evaluate is similar to selecting an expression in formula bar formulas and pressing the Recalculate key is F9 in Microsoft Excel for Windows. Evaluate replaces an expression with a value.
Operation Steps
1, select D1, and then in the menu bar select "Insert" → "name" → "Definition" pop-up "Definition name" dialog box.
2, then "name on the current worksheet" Enter "X", and then enter "=evaluate (sheet1! $A 1)" In the reference location formula bar, click "Add" in OK.
3, enter "=x" in cell D1.
Triple Recommendation: Click for free Download the latest version of WPS Office software "to see more computer tutorials
4, D1 can get the result. The formula can be copied down.