Amafomula nemisebenzi ku-Excel

• Ifaka ifomula
• Ukuhlela amafomula
• Ukusebenza Okubalulekile
• Kopisha/Namathisela ifomula
• Ifaka umsebenzi

Ifomula isisho esibala inani leseli. Imisebenzi ingamafomula achazwe ngaphambilini futhi isivele yakhelwe ku-Excel.

Ngokwesibonelo, emfanekisweni ongezansi, iseli A3 iqukethe ifomula elengeza amanani eseli A2 и A1.

Esinye isibonelo. Iseli A3 iqukethe umsebenzi ISUM (SUM), ebala isamba sobubanzi A1:A2.

=SUM(A1:A2)

=СУММ(A1:A2)

Ifaka ifomula

Ukufaka ifomula, landela imiyalelo engezansi:

1. Khetha iseli.
2. Ukwazisa i-Excel ukuthi ufuna ukufaka ifomula, sebenzisa uphawu olulinganayo (=).
3. Isibonelo, emfanekisweni ongezansi, kufakwe ifomula ehlanganisa amaseli A1 и A2.

   

Ithiphu: Esikhundleni sokuthayipha mathupha A1 и A2vele uchofoze kumaseli A1 и A2.

4. Shintsha inani leseli A1 ku-3.

   

   I-Excel ibala kabusha inani leseli ngokuzenzakalelayo A3. Lesi ngesinye sezici ezinamandla kakhulu ze-Excel.

Ukuhlela amafomula

Uma ukhetha iseli, i-Excel ibonisa inani noma ifomula kuseli kubha yefomula.

1. 1. Ukuze uhlele ifomula, chofoza ibha yefomula bese uhlela ifomula.

1. Cindezela Faka.

   

Ukusebenza Okubalulekile

I-Excel isebenzisa uhlelo olwakhelwe ngaphakathi lapho izibalo zenziwa khona. Uma ingxenye yefomula ikubakaki, izohlolwa kuqala. Khona-ke ukuphindaphinda noma ukuhlukaniswa kwenziwa. I-Excel izobe sengeza futhi isuse. Bheka isibonelo ngezansi:

Okokuqala, i-Excel iyaphindaphinda (A1*A2), bese yengeza inani leseli A3 kulomphumela.

Esinye isibonelo:

I-Excel iqala ibala inani kubakaki (A2 + A3), bese iphindaphinda umphumela ngosayizi weseli A1.

Kopisha/namathisela ifomula

Lapho ukopisha ifomula, i-Excel ilungisa ngokuzenzakalelayo izinkomba zeseli ngayinye entsha lapho ifomula ikopishwa khona. Ukuze uqonde lokhu, landela lezi zinyathelo:

1. Faka ifomula eboniswe ngezansi kuseli A4.

   

2. Gqamisa iseli A4, chofoza kwesokudla kuyo bese ukhetha umyalo Kopisha (Kopisha) noma cindezela isinqamuleli sekhibhodi Ctrl + C.

   

3. Okulandelayo, khetha iseli B4, chofoza kwesokudla kuyo bese ukhetha umyalo Insertion (Faka) esigabeni Namathisela Izinketho (Namathisela Izinketho) noma cindezela isinqamuleli sekhibhodi Ctrl + V.

   

4. Ungakwazi futhi ukukopisha ifomula kuseli A4 в B4 ukwelula. Gqamisa iseli A4, ibambe ikhoneni layo elingezansi kwesokudla bese uyihudulela kuseli V4. Kulula kakhulu futhi inikeza umphumela ofanayo!

   

   Umphumela: Ifomula kuseli B4 ibhekisela kumanani kukholamu B.

   

Ifaka umsebenzi

Yonke imisebenzi inesakhiwo esifanayo. Ngokwesibonelo:

SUM(A1:A4)

СУММ(A1:A4)

Igama lalo msebenzi lithi ISUM (SUM). Inkulumo ephakathi kwabakaki (izimpikiswano) isho ukuthi sinikeze ububanzi A1:A4 njengokufakwayo. Lo msebenzi wengeza amanani kumaseli A1, A2, A3 и A4. Ukukhumbula ukuthi yimiphi imisebenzi kanye nezimpikiswano okufanele zisetshenziswe kulowo nalowo msebenzi othile akulula. Ngenhlanhla, i-Excel inomyalo Faka umsebenzi (Faka umsebenzi).

Ukufaka umsebenzi, yenza okulandelayo:

1. Khetha iseli.
2. Chofoza inkinobho Faka umsebenzi (Faka umsebenzi).

   

   Ibhokisi lengxoxo legama elifanayo lizovela.

3. Sesha umsebenzi owufunayo noma uwukhethe esigabeni. Isibonelo, ungakhetha umsebenzi COUNTIF (COUNTIF) kusukela esigabeni izibalo (Izibalo).

   

4. Cindezela OK. Ibhokisi lengxoxo lizovela Ukuphikisana Komsebenzi (Izimpikiswano zomsebenzi).
5. Chofoza inkinobho engakwesokudla kwenkambu - (Ububanzi) bese ukhetha ububanzi A1:C2.
6. Chofoza kunkundla Imigomo (Criterion) bese ufaka “>5”.
7. Cindezela OK.

   

   Umphumela: I-Excel ibala inani lamaseli inani lawo likhulu kuno-5.

   =COUNTIF(A1:C2;">5")

   =СЧЁТЕСЛИ(A1:C2;">5")

   

Qaphela: Esikhundleni sokusebenzisa "Faka umsebenzi“, vele uthayiphe =COUNTIF(A1:C2,”>5”). Uma uthayipha »=COUNTIF(«, esikhundleni sokuthayipha ngesandla “A1:C2”, khetha lobu bubanzi ngegundane.