Daga cikin alamomi masu yawa da aka yi amfani da su a cikin kididdiga, kana buƙatar zaɓar lissafin bambancin. Ya kamata a lura cewa yin aiki tare tare da hannu yana aiki ne mai ban mamaki. Abin farin ciki, Excel yana da ayyuka don sarrafa tsarin lissafi. Nemo algorithm don aiki tare da waɗannan kayan aikin.
Daidaita ladabi
Rarraba shi ne ma'auni na bambancin, wanda shine matsakaicin matsakaicin ƙaura daga tsammanin. Ta haka ne, yana nuna bambancin lambobi dangane da ma'anar. Ana iya gudanar da lissafi na bambanta don yawancin jama'a, kuma don samfurin.
Hanyar 1: Ƙididdiga yawan yawan jama'a
Domin lissafin wannan alamar a Excel ga dukan yawan jama'a, ana amfani da aikin DISP.G. Harshen wannan magana shine kamar haka:
= SIFA G (Lamba 1; Lamba 2; ...)
Zamu iya amfani da jimlar 1 zuwa 255. Ƙididdiga na iya zama ko dabi'un lambobi ko kuma nassoshi ga sassan da suke dauke da su.
Bari mu ga yadda za'a tantance wannan darajar don kewayon tare da bayanan lambobi.
- Yi zaɓi na tantanin halitta a kan takardar, wanda za'a nuna sakamakon sakamakon lissafin bambancin. Danna maballin "Saka aiki"sanya a hagu na dabarun bar.
- Fara Wizard aikin. A cikin rukunin "Labarin lissafi" ko "Jerin jerin jerin sunayen" Yi bincike tare da sunan "DISP.G". Da zarar an samu, zaɓi shi kuma danna maballin "Ok".
- Kashe aikin muhawarar muhawara DISP.G. Saita siginan kwamfuta a filin "Number1". Zaži kewayon sel a kan takardar, wanda ya ƙunshi jerin jerin. Idan akwai nau'ukan irin wannan jeri, ana iya amfani dashi don shigar da haɗin su a cikin maƙallin shawara "Number2", "Number3" da sauransu Bayan an shigar da bayanai, danna kan maballin "Ok".
- Kamar yadda kake gani, bayan wadannan ayyukan, ana yin lissafi. Sakamakon yin lissafin bambancin yawan yawan jama'a yana nunawa a cikin cell da aka riga aka ƙayyade. Wannan shine ainihin tantanin halitta inda aka samo asali DISP.G.
Darasi: Maɓallin aiki na Excel
Hanyar 2: lissafin samfurin
Ya bambanta da lissafin adadin yawan yawan jama'a, a cikin lissafi don samfurin, ƙidaya ba ya nuna yawan adadin lambobi, amma ɗaya kasa. Anyi wannan don gyara kuskure. Excel yana la'akari da wannan nuni a cikin aikin musamman da aka tsara don irin wannan lissafin - DISP.V. Ana danganta siginar ta ta hanyar daftarin:
= DISP.V (Number1; Number2; ...)
Yawan muhawara, kamar yadda a cikin aikin da suka wuce, zai iya bambanta daga 1 zuwa 255.
- Zaɓi tantanin halitta kuma a daidai wannan hanya kamar yadda ya faru a baya, gudu Wizard aikin.
- A cikin rukunin "Jerin jerin jerin sunayen" ko "Labarin lissafi" nemi sunan "DISP.V". Bayan an samo samfurin, zaɓi shi kuma danna maballin "Ok".
- An kaddamar da taga na muhawarar aiki. Na gaba, muna ci gaba da daidai daidai lokacin da muka yi amfani da bayanin da aka rigaya: saita siginan kwamfuta a filin gwaji "Number1" kuma zaɓi yankin da ya ƙunshi jerin jerin a kan takardar. Sa'an nan kuma danna maballin. "Ok".
- Sakamakon lissafi za a nuna shi a cikin tantanin salula.
Darasi: Wasu ayyuka na lissafi a cikin Excel
Kamar yadda kake gani, shirin na Excel zai iya taimakawa wajen ƙididdige bambancin. Wannan ƙididdiga na iya ƙidaya ta aikace-aikacen, duka na yawan jama'a da na samfurin. A wannan yanayin, duk ayyukan da aka yi amfani da su sun rage kawai don ƙayyade kewayon lambobin sarrafawa, kuma Excel yayi babban aikin kanta. Hakika, wannan zai adana babban adadin lokaci mai amfani.
