In today’s Excel tips topic, I would like to introduce to you some basic math formulas, which anyone when learning and working with the Excel application must use. Yes, that’s the way Use formulas to calculate addition, subtraction, multiplication, and division in Excel files.
In fact, how to use these formulas and calculations is not as difficult as the functions that I have introduced in previous articles, and it only changes slightly from the common calculation method. However, so that you can understand and grasp more thoroughly the basic knowledge first, I will have a detailed guide for everyone to have a more thorough view.
OK, so let’s get started….
1. Instructions for performing addition on Excel
+ Step 1: You open the Excel file to create the formula to calculate the addition.
Then click on the box
Tổng (result cell) first as shown below and put equal sign
= => Next, you click on the box
Số hạng respectively => use the plus sign
+ to create the first argument for the calculation.
The specific example I have done is below.
+ Step 2: Then click
Số hạng second => press
Enter to complete the sum formula.
+ Step 3: Select the plus sign to
Fill formula down the list as shown. Or simply put for you to understand is to copy the formula to apply to the remaining number of rows.
And this is the result after I just finished Filling.
2. Instructions perform subtraction in Excel
+ Step 1: You open the Excel file to calculate the signal.
Similar to the sum formula, you choose the sign
= then click the box
Số bị trừ as shown => then press
– on the computer keyboard to generate the first argument.
+ Step 2: Then you click on the corresponding box
Số trừ => then press
Enter to generate formula result
+ Step 3: Next
Fill formula down to the cells in the list.
And we get the result as shown below.
3. Instructions for performing multiplication in Excel
+ Step 1: You open the Excel file, the calculation part
Tích of the multiplication you type the sign
= then click
Thừa số first.
In multiplication we use the key
* instead of the multiplication sign to make the first argument in the formula.
+ Step 2: Then, you click on the second argument ie the corresponding Second Factor => and then press
Enter to complete the result.
+ Step 3: Next, you also Fill the formula down the cells in the list to do the rest of the cells.
And we got the results.
4. Instructions for performing division in Excel
+ Step 1: You open the file to calculate the division. Then use
= then click
Số bị chia.
There is no similar division in the division calculation in Excel, so you enter a slash
/ as shown to create the first argument.
+ Step 2: Then you click on the box
Số chia corresponding => then
Enter to complete the formula.
+ Step 3: Then Fill the formula in part
Thương Output your list as shown.
And we have the final result:
Yes, that’s how I guide you guys how to perform addition, subtraction, multiplication and division in Excel files okay then. All in all, it’s very simple, isn’t it?
With the quick calculation method on Excel, it won’t take much time when you have to calculate such simple calculations in Casio calculators, but the exact ratio is not controversial, right.
And here, the tutorial on how to create addition, word, multiplication, and division calculations on Excel would also like to pause. Hope this basic trick will help you in your work and study better.
Good luck !
CTV: Luong Trung – techtipsnreview
Don’t forget to visit the self-study section of Excel to update your knowledge 🙂
The article achieved: 4.2/5 stars – (There are 10 reviews)
Note: Was this article helpful to you? Don’t forget to rate the article, like and share it with your friends and family!