Lissafin bambance-bambance a Microsoft Excel

Lissafin bambanci shine ɗayan ayyukan mashahuri cikin lissafi. Amma ana amfani da wannan lissafin ba kawai a cikin kimiyya ba. Kullum muna aiwatar dashi, ba tare da tunanin komai ba, a rayuwar yau da kullun. Misali, domin kirga canjin daga sayan a wani shago, ana kuma yin amfani da lissafin gano bambanci tsakanin adadin da mai siyar ya siyarwa mai siye da ƙimar kayan. Bari mu ga yadda za a ƙididdige bambanci a cikin Excel lokacin amfani da tsaran bayanai daban-daban.

Lissafi na Banbanci

Idan akai la'akari da cewa Excel na aiki tare da nau'ikan bayanai daban-daban, lokacin da ake rage darajar ɗaya daga wani, ana amfani da dabaru iri iri. Amma gaba ɗaya, ana iya rage su zuwa nau'in guda ɗaya:

X = A-B

Yanzu kuma bari mu bincika yadda za a rage ƙimar halaye na nau'ikan nau'ikan: lambobi, lamuni, kwanan wata da lokaci.

Hanyar 1: Maimaita lambobi

Nan da nan bari mu bincika zaɓin mafi sauƙin aiwatarwa don ƙididdige bambancin, wato ragi ƙimar lambobi. Don waɗannan dalilai, a cikin Excel zaka iya amfani da tsarin lissafi na yau da kullun tare da alama "-".

1. Idan kuna buƙatar aiwatar da adadin tsoffin lambobi ta amfani da Excel azaman kalkuleta, to saita alamar zuwa tantanin "=". Bayan haka, nan da nan bayan wannan alama, rubuta lambar ragewa daga maballin, sanya alamar "-"sannan a rubuta mai wanda aka cire. Idan akwai abubuwan cirewa da yawa, to kuna buƙatar sake sanya alamar "-" kuma rubuta lambar da ake buƙata. Ya kamata a aiwatar da hanyar alamomin ilmin lissafi da lambobi har sai an shigar da waɗanda aka rage. Misali, daga 10 cire 5 da 3, kuna buƙatar rubuta fom ɗin da zai biyo baya zuwa kayan aiki na Excel:

   =10-5-3

   Bayan yin rikodin furcin, don nuna sakamakon ƙididdigar, danna maɓallin Shigar.



2. Kamar yadda kake gani, an nuna sakamakon. Ya yi daidai da lamba 2.

Amma mafi yawancin lokuta, ana amfani da raguwa a cikin Excel tsakanin lambobin da aka sanya a sel. A lokaci guda, algorithm na aikin ilmin lissafi da kansa ya rage kusan canzawa, kawai a yanzu takamaiman maganganun lambobi, ana yin nassoshi ga sel a inda suke. Sakamakon binciken ya nuna a cikin wata takarda daban, inda aka saita alamar. "=".

Bari mu ga yadda za a lissafa bambanci tsakanin lambobin 59 da 26located kowane biyun a cikin kayan abubuwan tare da daidaitawa A3 da C3.

1. Mun zaɓi wani fanko na littafin wanda muke shirin nuna sakamakon ƙididdigar bambancin. Mun sanya alama a ciki "=". Bayan haka, danna kan wayar A3. Mun sanya alama "-". Kusa, danna kan takardar takardar. C3. A cikin takardar takardar don fitar da sakamako, tsarin da zai bi ya bayyana:

   = A3-C3

   Kamar yadda ya gabata, don nuna sakamako akan allo, danna maballin Shigar.



2. Kamar yadda kake gani, a wannan yanayin, ƙididdigar tayi nasara. Sakamakon lissafin daidai yake da lambar 33.

Amma a zahiri, a wasu halaye ana buƙatar aiwatar da raguwa, wanda duka lambobi masu ƙima da kansu da kuma haɗin haɗin sel waɗanda suke inda zasu shiga. Sabili da haka, wataƙila haɗuwa da magana, alal misali, na wannan tsari:

= A3-23-C3-E3-5

Darasi: Yadda za a cire lamba daga lamba a Excel

Hanyar 2: tsarin kudi

Lissafin dabi'u a cikin tsarin kudi ba shi da bambanci da na lamba. Ana amfani da dabaru iri ɗaya, tunda, gabaɗaya, wannan babban tsarin yana ɗaya daga cikin zaɓukan na lambobi. Bambancin kawai shine cewa a ƙarshen adadin da aka haɗa a cikin lissafin, an saita alamar monetary ta musamman kudin.

1. A zahiri, zaku iya aiwatar da aikin, kamar ragewar lambobi kamar yadda aka saba, sannan kawai za a tsara sakamako na ƙarshe don tsarin tsabar kuɗi. Don haka, muna yin lissafin. Misali, cire kaya daga 15 lamba 3.



2. Bayan haka, mun danna maballin takardar wanda ya ƙunshi sakamakon. A cikin menu, zaɓi ƙimar "Tsarin kwayar halitta ...". Madadin kiran menu na mahallin, zaku iya amfani da mabubbuga bayan zaɓi Ctrl + 1.



3. Tare da ɗayan zaɓuɓɓuka biyu, ana ƙaddamar da taga tsara. Mun matsa zuwa sashin "Lambar". A cikin rukunin "Lambobin adadi" zabin ya kamata a lura "Kudi". A lokaci guda, filaye na musamman zasu bayyana a ɓangaren dama na keɓar taga a ciki wanda zaku iya zaɓar nau'in kuɗin kuɗin da adadin wuraren adali. Idan kuna da Windows a gaba ɗaya kuma Microsoft Office musamman, keɓaɓɓu zuwa Rasha, to ta hanyar tsoho su kasance cikin shafi "Tsarin zane" alamar ruble, kuma a cikin filin na lamba "2". A mafi yawan lokuta, wadannan saiti basa buƙatar a canza su. Amma, idan har yanzu kuna buƙatar yin lissafi a daloli ko ba tare da adadi ba, to kuna buƙatar yin gyare-gyare masu mahimmanci.

   Bayan duk canje-canje da suka cancanta, yi danna "Ok".



4. Kamar yadda kake gani, sakamakon raguwa a cikin tantanin halitta an canza shi zuwa tsarin kudi tare da kafaffun wuraren adadi.

Akwai wani zaɓi don tsara sakamakon cire don tsarin tsabar kuɗi. Don yin wannan, a kan kintinkiri a cikin shafin "Gida" danna kan alwatika a dama na filin nuni na tsarin tantanin halitta na yanzu a cikin kungiyar kayan aiki "Lambar". Daga jerin da ke buɗe, zaɓi zaɓi "Kudi". Za'a canza lambobi zuwa lamuni. Gaskiya ne, a wannan yanayin babu yiwuwar zaɓin kuɗin da adadin wuraren adadi. Za'a yi amfani da wani zaɓi da aka saita ta tsohuwa a cikin tsarin, ko kuma saita shi ta taga yadda aka tsara a sama.

Idan kayi lissafin banbanci tsakanin dabi'un da ke cikin sel wadanda aka riga aka tsara su don tsabar kuxi, to tsara tsarin takardar don nuna sakamakon ba lallai bane. Za a tsara ta atomatik zuwa madaidaicin tsari bayan an shigar da dabara tare da alaƙa zuwa abubuwan da ke ɗauke da lambobi masu raguwa da raguwa, haka kuma ana yin danna maballin. Shigar.

Darasi: Yadda za a canza tsarin tantanin halitta a cikin Excel

Hanyar 3: kwanakin

Amma lissafin bambancin kwanakin yana da manyan abubuwan da suka bambanta da zaɓin da suka gabata.

1. Idan muna buƙatar rage adadin kwanakin daga ranar da aka nuna a ɗayan abubuwan da ke cikin takardar, to da farko mun saita alama "=" zuwa kashi inda za'a nuna sakamakon karshe. Bayan haka, danna kan ɓangaren takardar inda kwanan watan ya ƙunshi. Adireshin zai bayyana a cikin kayan fitarwa da kuma a cikin masarar dabara. Bayan haka muna sanya alamar "-" kuma tuƙa cikin yawan kwanakin da za a ɗauka daga keyboard. Don yin lissafin danna Shigar.



2. An nuna sakamakon a cikin tantanin halitta da muka tsara. A lokaci guda, tsarinta yana canzawa ta atomatik zuwa tsarin kwanan wata. Don haka, muna samun cikakkiyar kwanan watan da aka nuna.

Akwai wani halin da ake ciki lokacin da ake buƙatar rage wata daga wannan ranar don ƙayyade bambanci tsakanin su a cikin kwanaki.

1. Saita hali "=" a cikin tantanin halitta inda za a nuna sakamakon. Bayan haka, danna maɓallin takardar, wanda ya ƙunshi kwanan wata. Bayan an nuna adireshinta a cikin tsari, sanya alamar "-". Danna wayar da ke dauke da farkon kwanan wata. Saika danna Shigar.



2. Kamar yadda kake gani, shirin yayi lissafin adadin kwanakin tsakanin kwanakin da aka kayyade.

Hakanan za'a iya kirga bambanci tsakanin kwanakin ta amfani da aikin HADA. Yana da kyau saboda yana ba ku damar saitawa, tare da taimakon ƙarin hujja, a cikin abin da sassan ma'aunin bambanci za a nuna su: watanni, ranaku, da dai sauransu. Rashin dacewar wannan hanyar ita ce cewa aiki tare da ayyuka shine mafi rikitarwa fiye da na yau da kullun. Bugu da kari, ma'aikaci HADA ba a jera su ba Wizards na Aiki, sabili da haka, dole ne ka shigar da shi da hannu ta amfani da wadannan kalmomin:

= DATE (fara_date; karshen_date; raka'a)

"Fara kwanan wata" - gardamar dake wakiltar farkon kwanan wata ko hanyar haɗi zuwa gare ta wanda ke cikin ɗakun zanen takarda.

Ranar karewa - Wannan hujja ce ta hanyar kwanan wata ko nuni zuwa gare shi.

Muhawara mai ban sha'awa "Unit". Tare da shi, zaku iya zaɓar zaɓi na yadda sakamakon zai nuna. Ana iya gyara ta ta amfani da waɗannan dabi'u:

• "d" - an nuna sakamakon a cikin kwanaki;
• "m" - cikin cikakken watanni;
• "y" - cikin cikakken shekaru;
• "YD" - bambanci a cikin ranaku (ban da shekaru);
• "MD" - bambanci a cikin ranaku (ban da watanni da shekaru);
• "Ym" - bambanci a cikin watanni.

Don haka, a cikin yanayinmu, muna buƙatar lissafa bambanci a cikin ranakun tsakanin Mayu 27 da 14 Maris, 2017. Wadannan kwanakin suna cikin sel tare da daidaitawa B4 da D4, bi da bi. Mun sanya siginan kwamfuta a cikin kowane takardar wofi inda muke son ganin sakamakon ƙididdigar, sannan mu rubuta fom kamar haka:

= HANDLE (D4; B4; "d")

Danna kan Shigar kuma sami sakamakon ƙarshe na ƙididdige bambancin 74. Tabbas, tsakanin wadannan kwanuka ya cika kwana 74.

Idan ana buƙatar rage kwanakin iri ɗaya, amma ba tare da shigar da su cikin sel ba, to a wannan yanayin muna amfani da tsari mai zuwa:

= HANDLE ("03/14/2017"; "05/27/2017"; "d")

Latsa maɓallin Shigar. Kamar yadda kake gani, sakamakon abu daya ne, wanda aka samo shi ne ta wata hanyar daban.

Darasi: Yawan ranakun tsakanin ranakun a Excel

Hanyar 4: lokaci

Yanzu mun zo nazarin ilimin algorithm don rage lokaci a Excel. Ka'idar aiki ta kasance iri ɗaya ce yayin da aka rage kwanakin. Wajibi ne a cire abinda ya gabata daga wani lokaci.

1. Don haka, muna fuskantar matsalar gano mintina nawa sun shuɗe daga 15:13 zuwa 22:55. Muna rubuta waɗannan ƙimar lokacin a cikin sel daban a kan takardar. Abin sha'awa shine, bayan shigar da bayanan, za'a tsara abubuwan da ke cikin takarda ta atomatik don abun cikin idan ba a tsara su ba kafin. In ba haka ba, za a tsara su da hannu don kwanan wata. A cikin tantanin halitta wanda sakamakon nunin zai bayyana, sanya alama "=". Sannan mun danna abubuwan da ke dauke da wani lokaci na gaba (22:55). Bayan an nuna adreshin a cikin dabara, shigar da alamar "-". Yanzu danna mahimmin abu a kan takardar wanda a farkon lokacin yake (15:13) A cikin yanayinmu, mun sami tsari na tsari:

   = C4-E4

   Don aiwatar da lissafin, danna Shigar.



2. Amma, kamar yadda muke gani, an nuna sakamakon kaɗan a cikin hanyar da muke so. Mu kawai muna buƙatar bambanci a cikin mintuna, kuma ya bayyana awanni 7 da minti 42.

   Domin samun mintuna, ya kamata mu ninka sakamakon da ya gabata ta mai amfani 1440. Ana samun wannan coeff din ta hanyar ninka yawan mintuna a kowace awa (60) da awanni daya kowace rana (24).

Don haka, saita alama "=" a cikin kwayar da ba komai a kan takarda. Bayan haka, mun danna wannan shafin na bayanan inda bambancin rabewar lokacin yake (7:42) Bayan an daidaita abubuwan haɗin wannan sel a cikin dabara, danna kan alamar ninka (*) akan maballin, sannan akan shi muka sanya lamba 1440. Don samun sakamakon, danna Shigar.



3. Amma, kamar yadda muke gani, an sake nuna sakamakon ba daidai ba (0:00) Wannan ya faru ne saboda gaskiyar cewa lokacin da aka yawaita, kayan aikin an sake tsara su ta atomatik zuwa tsarin lokaci. Domin bambanci a cikin minti da za a nuna, muna buƙatar dawo da tsarin gaba ɗayan ta.



4. Don haka, zaɓi wannan tantanin a cikin shafin "Gida" danna kan alwatika wanda muka saba da shi zuwa dama na filin nuni. A jerin masu aiki, zaɓi zaɓi "Janar".

   

   Kuna iya yi daban. Zaɓi kashi da aka ƙayyade na takarda kuma latsa maɓallan Ctrl + 1. Tsarin tsarawa yana farawa, wanda muka riga muka magance tun farko. Matsa zuwa shafin "Lambar" kuma a cikin jerin tsararrun lambobi zaɓi zaɓi "Janar". Danna kan "Ok".



5. Bayan amfani da ɗayan waɗannan zaɓuɓɓukan, an sake tantanin tantanin halitta zuwa tsarin gama gari. Zai nuna bambanci tsakanin lokacin da aka ƙayyade a cikin mintuna. Kamar yadda kake gani, bambanci tsakanin 15:13 da 22:55 shine minti 462.

Darasi: Yadda ake sauya awa zuwa mintuna a cikin Excel

Kamar yadda kake gani, lambobin lissafin bambanci a cikin Excel sun dogara da bayanan bayanan da mai amfani yayi aiki da shi. Amma, duk da haka, akasin ƙa'idar kusancin wannan aikin na lissafi ya kasance ba canzawa. Wajibi ne a cire wani daga lamba daya. Ana iya cimma wannan ta yin amfani da dabarun lissafi waɗanda aka yi amfani da su yayin la’akari da mahimmancin ƙirar Excel, kazalika da amfani da ayyukan ginannun.