Formula da ayyuka a cikin Excel

• Shigar da dabara
• Tsarin gyarawa
• Gabatar da Aiki
• Kwafi/Manna dabara
• Saka aiki

Dabaru kalma ce da ke ƙididdige ƙimar tantanin halitta. Ayyuka an riga an tsara su kuma an riga an gina su cikin Excel.

Misali, a cikin hoton da ke ƙasa, tantanin halitta A3 ya ƙunshi dabarar da ke ƙara ƙimar tantanin halitta A2 и A1.

Misali guda daya. Cell A3 ya ƙunshi aiki SUM (SUM), wanda ke ƙididdige jimlar kewayon A1: a2.

=SUM(A1:A2)

=СУММ(A1:A2)

Shigar da dabara

Don shigar da dabarar, bi umarnin da ke ƙasa:

1. Zaɓi tantanin halitta.
2. Don sanar da Excel cewa kuna son shigar da dabara, yi amfani da alamar daidai (=).
3. Misali, a cikin hoton da ke ƙasa, an shigar da wata dabara wacce ta tara sel A1 и A2.

   

tip: Maimakon bugawa da hannu A1 и A2kawai danna kan sel A1 и A2.

4. Canja ƙimar tantanin halitta A1 akan 3.

   

   Excel yana sake lissafin ƙimar tantanin halitta ta atomatik A3. Wannan yana ɗaya daga cikin mafi kyawun fasalin Excel.

Tsarin gyarawa

Lokacin da ka zaɓi tantanin halitta, Excel yana nuna ƙima ko dabara a cikin tantanin halitta a mashaya dabara.

1. 1. Don gyara dabara, danna kan ma'aunin dabara kuma gyara dabarar.

1. latsa Shigar.

   

Gabatar da Aiki

Excel yana amfani da ginanniyar tsari wanda ake yin lissafin. Idan wani ɓangare na dabara yana cikin baka, za a fara tantance shi. Sa'an nan kuma ana yin ninka ko rarraba. Excel zai ƙara da raguwa. Dubi misali a ƙasa:

Na farko, Excel yana ninka (A1*A2), sannan yana ƙara darajar tantanin halitta A3 ga wannan sakamakon.

Wani misali:

Excel ya fara ƙididdige ƙima a cikin baka (A2+A3), sannan yana ninka sakamakon da girman tantanin halitta A1.

Kwafi/manna dabara

Lokacin da kuka kwafi dabara, Excel ta atomatik yana daidaita nassoshi ga kowane sabon tantanin halitta wanda aka kwafi dabarar a ciki. Don fahimtar wannan, bi waɗannan matakan:

1. Shigar da dabarar da aka nuna a ƙasa cikin tantanin halitta A4.

   

2. Hana tantanin halitta A4, danna-dama akansa kuma zaɓi umarni Copy (Kwafi) ko danna gajeriyar hanyar madannai Ctrl + C.

   

3. Na gaba, zaɓi tantanin halitta B4, danna-dama akansa kuma zaɓi umarni sa (Saka) a cikin sashe Manna Zabuka (Zaɓuɓɓukan Manna) ko danna gajeriyar hanyar keyboard Ctrl + V.

   

4. Hakanan zaka iya kwafi dabarar daga tantanin halitta A4 в B4 mikewa Hana tantanin halitta A4, riƙe ƙasan kusurwar dama ta ƙasa kuma ja shi zuwa tantanin halitta V4. Yana da sauƙin sauƙi kuma yana ba da sakamako iri ɗaya!

   

   Sakamako: Formula a cikin tantanin halitta B4 yana nufin ƙima a cikin ginshiƙi B.

   

Saka aiki

Duk ayyuka suna da tsari iri ɗaya. Misali:

SUM(A1:A4)

СУММ(A1:A4)

Sunan wannan aikin shine SUM (SUM). Magana tsakanin brackets (hujja) na nufin mun ba da iyaka A1: a4 kamar shigar. Wannan aikin yana ƙara ƙima a cikin sel A1, A2, A3 и A4. Tuna waɗanne ayyuka da muhawara don amfani da kowane takamaiman ɗawainiya ba abu ne mai sauƙi ba. Abin farin ciki, Excel yana da umarni Saka Ayyuka (Saka aikin).

Don saka aiki, yi waɗannan:

1. Zaɓi tantanin halitta.
2. latsa Saka Ayyuka (Saka aikin).

   

   Akwatin maganganu na suna ɗaya zai bayyana.

3. Nemo aikin da ake so ko zaɓi shi daga rukunin. Misali, zaku iya zaɓar aikin COUNTIF (COUNTIF) daga rukuni lissafi (Kididdiga).

   

4. latsa OK. Akwatin maganganu zai bayyana Hujjojin Aiki (Hujjojin aiki).
5. Danna maɓallin dama na filin - (Range) kuma zaɓi kewayo A1: c2.
6. Danna cikin filin sharudda (Criterion) kuma shigar da "> 5".
7. latsa OK.

   

   Sakamako: Excel yana ƙididdige adadin sel waɗanda darajarsu ta fi 5.

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

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

   

lura: Maimakon amfani da "Saka aiki", kawai rubuta = COUNTIF (A1: C2,"> 5"). Lokacin da ka rubuta »= COUNTIF(«, maimakon buga "A1:C2" da hannu, zaɓi wannan kewayon tare da linzamin kwamfuta.