Mafomu ndi ntchito mu Excel

• Kulowetsa fomula
• Kusintha mafomu
• Ntchito Yofunika Kwambiri
• Copy/Paste formula
• Kuyika ntchito

Fomula ndi mawu omwe amawerengera mtengo wa selo. Ntchito ndi ma formula omwe adafotokozedwa kale ndipo adapangidwa kale mu Excel.

Mwachitsanzo, mu chithunzi pansipa, selo A3 ili ndi ndondomeko yomwe imawonjezera ma cell values A2 и A1.

Chitsanzo china. Selo A3 lili ndi ntchito SUM (SUM), yomwe imawerengera kuchuluka kwa mulingo A1:A2.

=SUM(A1:A2)

=СУММ(A1:A2)

Kulowetsa fomula

Kuti mulembe fomula, tsatirani malangizo omwe ali pansipa:

1. Sankhani selo.
2. Kuti mudziwitse Excel kuti mukufuna kulemba fomula, gwiritsani ntchito chizindikiro chofanana (=).
3. Mwachitsanzo, mu chithunzi pansipa, ndondomeko yalembedwa yomwe imawerengera maselo A1 и A2.

   

Tip: M'malo molemba pamanja A1 и A2kungodinanso pa maselo A1 и A2.

4. Sinthani mtengo wa cell A1 pa 3.

   

   Excel imawerengeranso mtengo wa cell A3. Ichi ndi chimodzi mwazinthu zamphamvu kwambiri za Excel.

Kusintha mafomu

Mukasankha selo, Excel imawonetsa mtengo kapena fomula mu cell mu bar ya formula.

1. 1. Kuti musinthe fomula, dinani pa bar ya fomula ndikusintha fomula.

1. Press Lowani.

   

Ntchito Yofunika Kwambiri

Excel imagwiritsa ntchito dongosolo lopangidwira momwe mawerengedwe amapangidwira. Ngati mbali ya fomuyo ili m'makolo, idzawunikidwa poyamba. Ndiye kuchulukitsa kapena kugawa kumachitidwa. Kenako Excel idzawonjezera ndikuchotsa. Onani chitsanzo pansipa:

Choyamba, Excel imachulukitsa (A1*A2), kenako amawonjezera mtengo wa cell A3 ku zotsatira izi.

Chitsanzo china:

Excel choyamba imawerengera mtengo m'mabuleki (A2 + A3), kenako kuchulukitsa zotsatira ndi kukula kwa selo A1.

Koperani/kumata fomula

Mukakopera fomula, Excel imangosintha maumboni a selo iliyonse yatsopano yomwe fomulayo imakopera. Kuti mumvetse izi, tsatirani izi:

1. Lowetsani ndondomeko yomwe ili pansipa mu selo A4.

   

2. Onetsani selo A4, dinani kumanja kwake ndikusankha lamulo Koperani (Koperani) kapena dinani njira yachidule ya kiyibodi Ctrl + C.

   

3. Kenako, sankhani selo B4, dinani kumanja kwake ndikusankha lamulo Kuika (Ikani) mu gawo Ikani Zosankha (Paste Options) kapena dinani njira yachidule ya kiyibodi Ctrl + V.

   

4. Mukhozanso kukopera fomula kuchokera mu selo A4 в B4 kutambasula. Onetsani selo A4, gwirani pansi ngodya yake yakumanja ndikuyikokera ku selo V4. Ndizosavuta komanso zimapereka zotsatira zomwezo!

   

   Zotsatira: Fomula mu cell B4 amatanthauza zamtengo wapatali B.

   

Kuyika ntchito

Ntchito zonse zimakhala ndi dongosolo lofanana. Mwachitsanzo:

SUM(A1:A4)

СУММ(A1:A4)

Dzina la ntchitoyi ndi SUM (SUM). Mawu akuti pakati pa mabulaketi (makangano) amatanthauza kuti tapereka osiyanasiyana A1:A4 monga cholowa. Ntchitoyi imawonjezera zomwe zili m'maselo A1, A2, A3 и A4. Kukumbukira ntchito ndi mikangano yoti mugwiritse ntchito pa ntchito iliyonse sikophweka. Mwamwayi, Excel ili ndi lamulo Ikani Ntchito (Ikani ntchito).

Kuti muyike ntchito, chitani izi:

1. Sankhani selo.
2. atolankhani Ikani Ntchito (Ikani ntchito).

   

   Bokosi lazokambirana la dzina lomweli lidzawonekera.

3. Sakani ntchito yomwe mukufuna kapena sankhani kuchokera m'gulu. Mwachitsanzo, mukhoza kusankha ntchito COUNTIF (COUNTIF) kuchokera mgulu ziwerengero (Zowerengera).

   

4. Press OK. A dialog box adzaoneka Ntchito Zokangana (Zotsutsana za ntchito).
5. Dinani batani lakumanja kwa gawolo - (Range) ndikusankha mtundu A1:C2.
6. Dinani m'munda Zotsatira (Criterion) ndi kulowa "> 5".
7. Press OK.

   

   Zotsatira: Excel imawerengera kuchuluka kwa maselo omwe mtengo wake ndi woposa 5.

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

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

   

Zindikirani: M'malo mogwiritsa ntchito "Ikani ntchito", ingolemba =COUNTIF(A1:C2,">5"). Mukalemba »=COUNTIF(«, m'malo molemba pamanja "A1:C2", sankhani izi ndi mbewa.