Excel Excel Watsawa Kulawa

Daga cikin alamomi da yawa waɗanda ake amfani da su a ƙididdiga, ya zama dole don zaɓar lissafin watsawa. Ya kamata a lura cewa aiwatar da wannan lissafin shine babban aiki mai ban mamaki. An yi sa'a, Excel Aikace-aikace yana da ayyuka waɗanda ke ba ka damar sarrafa tsarin lissafin. Mun gano algorithm don aiki tare da waɗannan kayan aikin.

Lissafin watsawa

Watsawa alama ce ta bambancin, wacce ita ce matsakaicin murabba'in karkacewa daga tsammanin lissafi. Don haka, yana bayyana lambobin watsa masu dangantaka da matsakaicin darajar. Yawan watsawa na iya aiwatar da duka yawan da samfurin.

Hanyar 1: Lissafi da Babban Aikin Janar na Janar

Don lissafa wannan mai nuna alama a Excel, babban tsarin saita yana amfani da aikin nuni. Syntax na wannan magana tana da tsari mai zuwa:

= D.g (lamba1; lamba2; ...)

Ana iya amfani da muhawara zuwa 255. Kamar yadda muhawara za su iya yin aiki azaman lambobi da nassoshi ga sel wanda suke kunsa.

Bari mu ga yadda ake lissafta wannan darajar don kewayon lamba tare da lambobi.

1. Muna samar da zabin tantanin halitta a kan wanda sakamakon watsawa za a nuna shi. Latsa maɓallin "Saka bayanai", sanya shi a gefen hagu na kirtani.



2. Jagora na Ayyuka ya fara. A cikin '' '' '' '' '' jerin haruffa ko "Cikakken jerin haruffa", muna yin bincike don jayayya tare da sunan "kafa". Bayan an samo shi, muna ware shi kuma danna maɓallin "Ok".



3. Nunin nuni na nuna aikin yana gudana. Shigar da siginan kwamfuta a filin "lamba". Mun ware kewayon sel a kan takardar, wanda ya ƙunshi lambar lamba. Idan akwai waɗannan jeri, to, zaku iya amfani da daidaitawa a cikin "lamba2", "lamba" taga taga, da sauransu. Bayan an yi duk bayanan, danna maɓallin "Ok".



4. Kamar yadda kake gani, bayan waɗannan ayyukan da aka lissafta. Sakamakon lissafin girman bambance-bambancen da babban tsarin an nuna shi a cikin tantanin da aka riga aka yanke. Wannan shine ainihin tantanin halitta wanda ke da dabara na reshen yana kai tsaye.

Darasi: Jagora na Ayyuka a Fore Fim

Hanyar 2: lissafin samfuri

Ya bambanta da lissafin darajar gwargwadon tsarin tsara, a cikin lissafin samfurin a cikin Denominator, ba jimlar lambobi ba, amma ƙasa ɗaya. Ana yin wannan ne don gyara kuskuren. Excel yana la'akari da wannan a zahiri a cikin aiki na musamman, wanda aka yi nufin wannan nau'in kuɗin - DON.V. Syntax yana wakiltar da wannan tsari mai zuwa:

= D (lamba1; lamba2; ...)

Yawan muhawara, kamar yadda a cikin aikin da ya gabata, na iya canzawa daga 1 zuwa 255.

1. Muna haskaka tantanin halitta kuma ta wannan hanyar da ta gabata, muna ƙaddamar da ayyukan da ayyukan.



2. A cikin rukunin "Cikakken jerin haruffa" ko "ƙididdiga" suna neman suna "dis.v.". Bayan an samo dabara, muna ware shi kuma mu sanya danna maɓallin "Ok".



3. Ana ƙaddamar da aikin muhawara muhawara. Bayan haka, muna yin cikakken a irin wannan hanya, kamar yadda lokacin amfani da mai amfani da baya: Mun saita siginan kwamfuta a cikin "lamba" kuma zaɓi yankin da ke ɗauke da lissafin lamba akan takardar. Sannan danna maballin "Ok".



4. Sakamakon lissafin za a cire a cikin sel daban.

Darasi: Sauran ayyuka na ƙididdiga a fice

Kamar yadda kake gani, shirin Excel Shafewa yana da damar sauƙaƙe lissafin watsawa. Za'a iya lissafin darajar ilimin lissafi ta aikace-aikacen, duka mutane gaba ɗaya da samfurin. A wannan yanayin, duk ayyukan mai amfani sun rage kawai ga nuni da kewayon da aka sarrafa da aka sarrafa, da kuma babban aikin da yake yi. Tabbas, zai ceci lokacin mai amfani lokacin.