How to batch calculate addition, subtraction, multiplication and division in Excel

How to easily perform addition, subtraction, multiplication and division operations in batches in Excel? PHP editor Zimo provides you with detailed operation methods to help you process data efficiently and improve office efficiency. Continue reading this article to learn the steps and formulas to master batch calculations in Excel.

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, and then set it as the cell where the calculation result is displayed. In the [Use to Formula] menu under [Define Name], select the [We just set] in the [Use to Formula] menu. calculate】.

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

The above is the detailed content of How to batch calculate addition, subtraction, multiplication and division in Excel. For more information, please follow other related articles on the PHP Chinese website!