1. If you want to directly calculate the calculation formula in this cell in another cell, then: If the formula is in D 1 and the result is in E2, select E2, press CTRL+F3, and take a name such as: =ABC, reference range: = evaluate (substitute (D 1, ". Drop-down fill. Pay attention to ensure the integrity of your calculation formula, and the operation symbols cannot be omitted.

2. If you want to operate directly in the cell, just add an equal sign in front of it.