How to Do Addition, Subtraction, Multiplication & Division in Excel
Charlotte Miller
Cรกch thแปฑc hiแปn phรฉp tรญnh Operacรกc thao tรกc trong Excel
In this tutorial, we are going to perform basic arithmetic operations i.e. addition, subtraction, division and multiplication. The following table shows the data that we will work with and the results that we should expect.
| S / N | Toรกn Tแปญ Sแป Hแปc | Sแป ฤแบฆU TIรN | Sแป THแปจ HAI | KแบพT QUแบข |
|---|---|---|---|---|
| 1 | Phรฉp cแปng (+) | 13 | 3 | 16 |
| 2 | Subtraction (-) | 21 | 9 | 12 |
| 3 | Phรขn cรดng (/) | 33 | 12 | 2.75 |
| 4 | Phรฉp nhรขn (*) | 7 | 3 | 21 |
Bรขy giแป chรบng ta hรฃy sแปญ dแปฅng Microsoft excel ฤแป ฤแบกt ฤฦฐแปฃc kแบฟt quแบฃ trรชn
Bฦฐแปc 1) Tแบกo bแบฃng Excel vร nhแบญp dแปฏ liแปu
Tแบกo mแปt thฦฐ mแปฅc trรชn mรกy tรญnh cแปงa bแบกn trong thฦฐ mแปฅc tร i liแปu cแปงa tรดi vร ฤแบทt tรชn cho nรณ Guru99 Hฦฐแปng dแบซn Excel
ฤแปi vแปi hฦฐแปng dแบซn nร y, chรบng tรดi sแบฝ sแปญ dแปฅng Microsoft Excel 2013. Tin vui lร ngay cแบฃ khi bแบกn cรณ Microsoft Excel 2007 hoแบทc 2010, bแบกn vแบซn cรณ thแป lร m theo hฦฐแปng dแบซn vร nhแบญn ฤฦฐแปฃc kแบฟt quแบฃ tฦฐฦกng tแปฑ.
Mแป Excel. Bแบกn sแบฝ nhแบญn ฤฦฐแปฃc mแปt cแปญa sแป tฦฐฦกng tแปฑ nhฦฐ cแปญa sแป hiแปn thแป bรชn dฦฐแปi. Triแปn vแปng cแปงa Excel sแบฝ phแปฅ thuแปc vร o phiรชn bแบฃn cแปงa bแบกn.
- Nhแบญp dแปฏ liแปu vร o bแบฃng tรญnh cแปงa bแบกn nhฦฐ trong hรฌnh trรชn.
- Bรขy giแป chรบng ta sแบฝ thแปฑc hiแปn cรกc phรฉp tรญnh bแบฑng cรกch sแปญ dแปฅng cรกc toรกn tแปญ sแป hแปc tฦฐฦกng แปฉng. Khi thแปฑc hiแปn cรกc phรฉp tรญnh trong Excel, bแบกn phแบฃi luรดn bแบฏt ฤแบงu bแบฑng dแบฅu bแบฑng (=).
- Chรบng ta hรฃy bแบฏt ฤแบงu vแปi phรฉp cแปng. Viแบฟt cรกc phรฉp tรญnh sau cรดng thแปฉc trong E2 Excel (cแปt kแบฟt quแบฃ)
- = C2 + D2
ฤรY,
- ฤn รฝ yรชu cแบงu Excel ฤรกnh giรก bแบฅt cแปฉ ฤiแปu gรฌ theo sau dแบฅu bแบฑng
- "C2" lร ฤแปa chแป รด cแปงa sแป ฤแบงu tiรชn ฤฦฐแปฃc cho bแปi C ฤแบกi diแปn cho chแปฏ cรกi cแปt vร 2 ฤแบกi diแปn cho sแป hร ng
- โD2โ lร ฤแปa chแป รด cแปงa sแป thแปฉ hai ฤฦฐแปฃc cho bแปi D ฤแบกi diแปn cho chแปฏ cรกi cแปt vร 2 ฤแบกi diแปn cho sแป hร ng
Nhแบฅn phรญm enter trรชn bร n phรญm khi hoร n tแบฅt. Kแบฟt quแบฃ lร bแบกn sแบฝ nhแบญn ฤฦฐแปฃc 16.
Using the knowledge gained in the above example, try to write the formulas for subtraction, division, and multiplication.
Tแบฃi xuแปng tแปp Excel แป trรชn Code
Bฦฐแปc 2) ฤแปnh dแบกng dแปฏ liแปu trong Microsoft Excel
Tแบฅt cแบฃ chรบng ta ฤแปu yรชu thรญch nhแปฏng ฤiแปu ฤแบนp ฤแบฝ phแบฃi khรดng? ฤแปnh dแบกng trong Excel giรบp chรบng ta ฤแบกt ฤฦฐแปฃc chรญnh xรกc ฤiแปu ฤรณ. Chรบng ta cรณ thแป lร m cho bแบฃng tรญnh cแปงa mรฌnh dแป trรฌnh bร y hฦกn. Chรบng ta sแบฝ sแปญ dแปฅng dแปฏ liแปu trong bแบฃng phรฉp tรญnh sแป hแปc. Chรบng tรดi sแบฝ ฤแบทt tรชn cแปt;
- Bold
- Cฤn chแปnh sแป serial sang trรกi
-
ฤรณng gรณi dแปฏ liแปu vร o cรกc hแปp.
Bฦฐแปc 3) In ฤแบญm tรชn cแปt
- ฤรกnh dแบฅu cรกc รด cรณ tรชn cแปt bแบฑng cรกch kรฉo chรบng.
- Bแบฅm vร o nรบt in ฤแบญm ฤฦฐแปฃc ฤแบกi diแปn bแปi B chแป huy.
- Sแป lร m viแปc cแปงa bแบกn bรขy giแป sแบฝ xuแบฅt hiแปn nhฦฐ sau
Bฦฐแปc 4) Cฤn chแปnh dแปฏ liแปu sang trรกi
-
Chรบng ta sแบฝ cฤn chแปnh dรฃy sแป แป bรชn trรกi
- ฤรกnh dแบฅu tแบฅt cแบฃ dแปฏ liแปu trong cแปt S/N
- Bแบฅm vร o cฤn lแป trรกi nhฦฐ hรฌnh bรชn dฦฐแปi
Bฦฐแปc 5) ฤรญnh kรจm dแปฏ liแปu vร o Boxes
ฤรกnh dแบฅu tแบฅt cแบฃ cรกc cแปt vร hร ng cรณ dแปฏ liแปu
Trรชn thanh ribbon font chแปฏ cรกc bแบกn nhแบฅn vร o lแปnh viแปn nhฦฐ hรฌnh dฦฐแปi.
Bแบกn sแบฝ nhแบญn ฤฦฐแปฃc menu thแบฃ xuแปng sau
Chแปn tรนy chแปn โTแบฅt cแบฃ cรกc ฤฦฐแปng viแปnโ.
Dแปฏ liแปu cแปงa bแบกn bรขy giแป sแบฝ trรดng nhฦฐ sau
Sแปญ dแปฅng kiแบฟn โโthแปฉc thu ฤฦฐแปฃc แป trรชn, hรฃy thแปญ thay ฤแปi mร u phรดng chแปฏ vร thแปญ cรกc tรนy chแปn khรกc cรณ sแบตn trรชn tab Trang chแปง.
Bฦฐแปc 6) ฤแบทt vรนng in, xem trฦฐแปc bแบฃn in & bแป cแปฅc trang
Vรนng in lร phแบงn cแปงa bแบฃng tรญnh mร bแบกn muแปn in ra giแบฅy. Cรกch nhanh chรณng vร dแป dร ng ฤแป thแปฑc hiแปn lร sแปญ dแปฅng cรกc lแปnh phรญm tแบฏt sau
Ctrl + P
Bแบกn sแบฝ nhแบญn ฤฦฐแปฃc bแบฃn xem trฦฐแปc khi in sau.
Nhแบฅn nรบt Esc ฤแป thoรกt chแบฟ ฤแป xem trฦฐแปc bแบฃn in
Thanh ribbon thiแบฟt lแบญp trang cรณ mแปt sแป tรนy chแปn nhฦฐ hฦฐแปng, kรญch thฦฐแปc, v.v. Hรฃy thแปญ รกp dแปฅng cรกc cร i ฤแบทt khรกc nhau vร sแปญ dแปฅng phรญm tแบฏt Ctrl + P ฤแป xem trฦฐแปc cรกc hiแปu แปฉng trรชn trang tรญnh.
Tแปng kแบฟt
Trong bร i viแบฟt nร y, chรบng ta ฤรฃ hแปc cรกch thแปฑc hiแปn cรกc phรฉp tรญnh sแป hแปc cฦก bแบฃn bแบฑng Excel, ฤแปnh dแบกng dแปฏ liแปu, Cรกch ฤแบทt vรนng in vร in (Chแบฟ ฤแป xem bแบฃn in).
