I believe that many beginners still don’t know the steps for batch calculation of addition, subtraction, multiplication and division in Excel. This article will tell you about the operation content of batch calculation of addition, subtraction, multiplication and division in Excel. Friends in need should take a look together!

Take the table below as an example.

Click the [Formula] option bar, select [Define Name] in it, and fill in the calculation in the name. Of course, you can also fill in what you need. In the reference position, we enter =evaluate(A2). Note that A2 in the brackets is the cell you want to calculate. It depends on the actual situation.

After inputting, click OK, then set it as the cell where the calculation results are displayed, and select the [Calculation] we just set in the [Use to Formula] menu under [Define Name].

Press Enter to fill, and then all cells will be filled.

The above has explained the steps for batch calculation of addition, subtraction, multiplication and division in Excel. I hope friends in need can learn it.