The method of converting a calculated formula to the result of an operation in Excel

For this kind of problem, you can use the Macro table function evaluate function to implement.

Macro-table functions, also known as Excel 4.0 functions, need to be defined by name (and enable macros) or in a macro table, where most function features are gradually replaced by built-in functions and VBA features.

For more information about enabling macros and add-ins, see another tutorial in the Office Assistant network:

Http://www.officezhushou.com/office/Addin.html

The specific solution to this problem is as follows:

1. Select cell B2 (the cell selected when defining the name relates to the specific wording of the relative reference address in the definition name formula)

2, click Insert-name-definition on the menu bar, open the Define Name dialog box, enter a name in the upper text box, such as EVL, and then enter the definition formula "=evaluate (A2)" In the lower section, and click OK to complete.

3, then in the B2 cell input formula "=EVL" can calculate the A2 cell calculation results. Formulas can be copied down, and other calculations can also be calculated.

The results are shown in the following illustration: