1.evaluate is mainly used to calculate the results of cells in user-defined names, and can be used in all versions 03 ~ 10.

2. In version 20 10, the operation of defining a name is as follows: (menu bar) Formula-Define a name-(in a new window) Enter "result" or other names in the name, enter =evaluate(A 1) in the reference position or enter other reference positions in brackets. 3. Then enter the formula = result in cell B 1.