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.

How to perform Add, Subtract, Multiply, and Divide calculations on Excel

+ Step 2: Then click Số hạng second => press Enter to complete the sum formula.

How to perform Add, Subtract, Multiply, and Divide calculations on Excel

+ 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.

How to perform Add, Subtract, Multiply, and Divide calculations on Excel

And this is the result after I just finished Filling.

How to perform Add, Subtract, Multiply, and Divide calculations on Excel

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.

How to perform Add, Subtract, Multiply, and Divide calculations on Excel

+ Step 2: Then you click on the corresponding box Số trừ => then press Enter to generate formula result

How to perform Add, Subtract, Multiply, and Divide calculations on Excel

+ Step 3: Next Fill formula down to the cells in the list.

How to perform Add, Subtract, Multiply, and Divide calculations on Excel

And we get the result as shown below.

How to perform Add, Subtract, Multiply, and Divide calculations on Excel

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.

How to perform Add, Subtract, Multiply, and Divide calculations on Excel

+ Step 2: Then, you click on the second argument ie the corresponding Second Factor => and then press Enter to complete the result.

How to perform Add, Subtract, Multiply, and Divide calculations on Excel

+ Step 3: Next, you also Fill the formula down the cells in the list to do the rest of the cells.

How to perform Add, Subtract, Multiply, and Divide calculations on Excel

And we got the results.

How to perform Add, Subtract, Multiply, and Divide calculations on Excel

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.

How to perform Add, Subtract, Multiply, and Divide calculations on Excel

+ Step 2: Then you click on the box Số chia corresponding => then Enter to complete the formula.

How to perform Add, Subtract, Multiply, and Divide calculations on Excel

+ Step 3: Then Fill the formula in part Thương Output your list as shown.

How to perform Add, Subtract, Multiply, and Divide calculations on Excel

And we have the final result:

How to perform Add, Subtract, Multiply, and Divide calculations on Excel

Epilogue

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!

TECH NEWS RELATED

Instructions to create an Android phone password that changes every hour

How to create an Android phone password that changes every hour will be an interesting thing that you can choose on your device with a password layer that is not fixed and people who always borrow your device will not be able to unlock the device. our Android device easily. ...

View more: Instructions to create an Android phone password that changes every hour

Base 13-Inch MacBook Pro With M2 Chip Has Significantly Slower SSD Speeds

Following the launch of Apple’s new 13-inch MacBook Pro with the M2 chip, it has been discovered that the $1,299 base model with 256GB of storage has significantly slower SSD read/write speeds compared to the equivalent previous-generation model. YouTube channels such as Max Tech and Created Tech tested the 256GB ...

View more: Base 13-Inch MacBook Pro With M2 Chip Has Significantly Slower SSD Speeds

How to watch YouTube videos anonymously on Android phones

In this article, TechtipsNReview.com will introduce a new feature of Youtube that is to watch YouTube videos anonymously on Android phones. This is an extremely convenient thing that you can choose to use on your device. How to watch Youtube Videos offline without internet on Android phones, iPhones How to ...

View more: How to watch YouTube videos anonymously on Android phones

iPhone Keeps Disconnecting from WiFi: How to Fix?

If your iPhone Keeps Disconnecting from WiFi, you will have a hard time browsing, texting or getting anything else done on your device. iPhone Keeps Disconnecting from WiFi While users have reported the issue of WiFi Disconnecting from WiFi Network after an iOS update, this problem can occur at any ...

View more: iPhone Keeps Disconnecting from WiFi: How to Fix?

How to adjust the screen brightness of Android phones

To protect the user’s eyes, how to adjust the screen brightness of your Android phone is something you should do during the use of this device. Especially for low-light environments, adjusting the screen brightness appropriately will help you use the device longer and safer. Change screen brightness on Samsung Galaxy ...

View more: How to adjust the screen brightness of Android phones

Dead By Daylight x Fortnite crossover a possibility

Many are surprised to learn that Dead by Daylight may soon be doing a crossover with Fortnite.

View more: Dead By Daylight x Fortnite crossover a possibility

ApeCoin Gains 22% After Debut of Bored Ape-Themed Video With Eminem and Snoop Dogg

The bump signifies a minor recovery for the token, which recently shed over 65% of its value in a single month.

View more: ApeCoin Gains 22% After Debut of Bored Ape-Themed Video With Eminem and Snoop Dogg

Divinity Original Sin 2 encountered an unrecoverable DirectX error

Are you experiencing DirectX Error in Divinity Original Sin 2? Divinity Original Sin 2 is a popular role-playing video game developed by Larian Studios. While gamers have an amazing time playing the game, they also run into some errors here and there. One such error is DirectX Error which a ...

View more: Divinity Original Sin 2 encountered an unrecoverable DirectX error

iPhone hangs on apple: Causes and ways to fix it

Instructions to bring the gesture navigation bar of OnePlus 6 to another Android phone

Instructions on how to make video calls between Android phones

How to Silence Unknown Callers to Stop Robocall Spam on iPhone

Razer’s Huntsman Mini unclutters your desk, but it might not be suitable for everyone

Odd Inputs And Peculiar Peripherals: Chorded Keyset Recreates Engelbart’s Vision

MSCOREE.DLL not found or is missing on Windows 11/10

How to create a bookmark save in Fire Emblem Warriors: Three Hopes

6 Best Ways to Fix Moisture Detected Error on Samsung Galaxy Phones

How To Read Enchanting Table Language in Minecraft

DVD Won’t Play On Windows 10? Try These 8 Best Fixes

How To Add An App To LG Smart TV? 5 Best Ways

OTHER TECH NEWS

Top Car News Car News