Ka'idodi na musamman: 4 hanyoyi masu sauki

Lissafin banbanci shine ɗayan mafi mashahuri ayyuka a lissafi. Amma wannan lissafin ba kawai a cikin kimiyya. Kullum muna aiwatar da shi koyaushe, ba tare da tunani ba, kuma a rayuwar yau da kullun. Misali, domin yin lissafin isar da sayan a cikin shagon, an kuma yi amfani dashi don lissafin banbanci tsakanin adadin da mai siye ya ba da mai siyarwa, kuma farashin kaya. Bari mu ga yadda za a lissafa bambancin bambanci lokacin amfani da tsarin bayanai daban-daban.

Lissafin bambanci

La'akari da cewa fixa aiki tare da tsari na bayanai daban-daban, lokacin rage darajar daya daga wani, ana amfani da bambance bambancen bambance-bambancen daban daban. Amma gabaɗaya, komai na iya raguwa ga nau'in guda:

X = A-b

Kuma yanzu bari mu kalli yadda ƙimar ƙira da aka cire: tallace-tallace da kuɗi, kwanakin da lokaci.

Hanyar 1: Rubuta lambobi

Nan da nan bari muyi la'akari da bambance-bambancen da aka saba wanda aka saba da lissafin banbanci na banbanci, wato cirewar ƙimar lambobi. Don waɗannan dalilai, tsarin lissafi na lissafi tare da alamar "-" ana iya amfani da shi a cikin excelele.

1. Idan kana buƙatar yin ragewar lambobi ta amfani da Excel, a matsayin kalkuleta, sannan saita alama "=" alama a cikin tantanin halitta. Bayan haka bayan wannan alamar, lambar ya ragu daga keyboard ya kamata a yi rikodin, "Sanya alamar" - ", sannan a yi rikodin ɗaya. Idan an cire ku ɗan lokaci, to kuna buƙatar sanya alama ta "-" sake kuma rikodin lambar da ake so. Hanyar musayar alamar alamar lissafi da lambobi ya kamata a aiwatar har sai an shigar da ƙananan ƙananan ƙananan. Misali, daga cikin 10 na mari 5 da 3, kuna buƙatar rubuta lissafin masu zuwa zuwa ɓangaren da aka fifita Expe:

   = 10-5-3.

   Bayan rubuta magana, don samun sakamakon ƙidaya, danna kan maɓallin Shigar.



2. Kamar yadda kake gani, sakamakon ya bayyana. Daidai yake da lamba 2.

Amma da muhimmanci sau da yawa ana amfani da tsarin kasawa a Ecelcel a tsakanin lambobin da aka sanya a cikin sel. A lokaci guda, ana amfani da algorithm na ilimin lissafi kusan ba a canza ba, kawai yanzu maimakon takamaiman adadin maganganu, ana amfani da su. An nuna sakamakon a cikin wani abu daban na takardar, inda halayyar "=" an shigar.

Bari mu ga yadda ake lissafin banbanci tsakanin lambobi 59 da 26, wanda yake bi da bi da abubuwan da ke tattare da daidaitawar takardar A3 da C3.

1. Zaɓi wani abu na littafin da muke shirin nuna sakamakon lissafin banbanci. Mun sanya shi a ciki alamar "=". Bayan haka, danna kan tantanin A3. Mun sanya alamar "-". Bayan haka, muna yin latsa kashi na takardar c3. Wannan tsari ya bayyana a cikin takardar kayan don fitarwa na sakamakon:

   = A3-C3

   Kamar yadda a cikin lamarin da ya gabata, don nuna sakamako akan allon, danna maɓallin Shigar.



2. Kamar yadda muke gani, a wannan yanayin lissafin an yi shi cikin nasara. Sakamakon ƙididdigar daidai yake da lamba 33.

Amma a zahiri, a wasu halaye, ya zama dole a sanya ɗakunan da za su shiga, duka biyun dabi'u da hanyoyin sadarwa zuwa sel inda suke. Saboda haka, magana, alal misali, kamar haka:

= A3-23-C3-E3-5

Darasi: Yadda ake rage lambar daga Exale

Hanyar 2: Tsarin tsabar kudi

Lissafin dabi'un a cikin tsarin tsabar kudi ba ya banbanta da yawa. Ana amfani da dabarun dabarun, tunda, da babba, wannan tsari yana ɗaya daga cikin lambobi da yawa. Bambancin shine kawai a ƙarshen dabi'un da ke halartar lissafin, alamar kuɗi ta kowane irin kuɗi.

1. A zahiri, zaku iya gudanar da aiki a matsayin ragewar lambobi, sannan kawai sannan tsara sakamakon ƙarshe don tsarin tsabar kuɗi. Don haka, muna samar da lissafi. Misali, zai rage daga cikin lambar 15th 3.



2. Bayan haka, danna kan kayan takardar, wanda ya ƙunshi sakamakon. A cikin menu, zaɓi darajar "tsarin tantanin halitta ...". Maimakon kiran menu na mahallin, zaku iya amfani bayan zaɓi na maɓallan Ctrl + 1.



3. Tare da kowane ɗayan zaɓuɓɓukan da aka ƙayyade biyu, an ƙaddamar da taga taga. Matsawa cikin sashin "lamba". A cikin "Lambobi na adadi" ya kamata a lura da zaɓin "kuɗi". A lokaci guda, filayen musamman zasu bayyana a gefen dama na taga ta taga, wanda zaku iya zaɓar nau'in kuɗi da kuma alamun ƙimar kuɗi. Idan kana da Windows gaba ɗaya da Microsoft Ofishin Microsoft, musamman, ƙaƙƙarfan manufa don Rasha ta zama dole alama ce ta Rasha, kuma a fagen alamun desal, lambar "2". A cikin mafi yawan lokuta, ana buƙatar waɗannan saitunan. Amma, idan har yanzu kuna buƙatar yin lissafi a dala ko ba tare da alamun ƙimar ba, ana buƙatar yin daidaitattun abubuwa masu mahimmanci.

   Bayan yadda ake yin canje-canje da ake buƙata, yumbu akan "Ok".



4. Kamar yadda muke gani, sakamakon raguwa a cikin tantanin halitta an canza shi zuwa tsarin tsabar kuɗi tare da adadin alamun alamun ƙasa.

Akwai wani zaɓi don tsara sakamakon sakamakon rage tsarin tsabar kuɗi. Don yin wannan, kuna buƙatar danna kintinkiri a cikin "gida" a kan alwatika wanda yake kan hannun filin nuni na yanzu a cikin "lambar" don kayan aiki. Daga jerin buɗewa, zaɓi zaɓi "zaɓi". Za'a canza ƙimar lambobi zuwa tsabar kuɗi. Gaskiya ne, a wannan yanayin, babu yiwuwar zabar kuɗi da yawan alamun alamun. Wani bambance-bambancen da aka saita a cikin tsarin tsoho, ko kuma an saita shi ta hanyar tsara taga da muka ambata a sama.

Idan ka lissafa bambancin tsakanin dabi'un da aka riga an tsara shi don tsarin tsabar kudi, sannan ka tsara kayan ganye don fitowar sakamakon ba ma haka. Za a tsara ta atomatik a ƙarƙashin tsarin da ya dace bayan an shigar da dabara tare da hanyoyin haɗi da ke da ragi da rage lambobi, da kuma danna maɓallin Shigar.

Darasi: Yadda za a canza tsarin tantanin halitta

Hanyar 3: kwanakin

Amma lissafin kwanakin kwanan wata yana da mahimman abubuwa dabam dabam dabam da zaɓuɓɓukan da suka gabata.

1. Idan muna buƙatar cire wasu adadin ranakun daga ranar da aka ƙayyade a ɗayan abubuwan a kan takardar, = "alama ce ta saita" = "alamar saita" = "ta sanya alama ta" = "a cikin abin da za'a nuna sakamakon ƙarshe. Bayan haka, danna kan takardar takarda, inda ranar ta ƙunshi. Adireshin sa za a nuna shi a cikin fitowar fitarwa kuma a cikin ƙirar formula. Bayan haka, mun saita alamar "-" kuma mika yawan kwanakin daga keyboard ɗin da kuke buƙatar ɗaukar shi. Domin yin lissafin yumbu akan shiga.



2. Ana nuna sakamakon a cikin tantanin halitta. A wannan yanayin, tsarin sa yana canzawa ta atomatik zuwa tsarin kwanan wata. Don haka, muna samun cikakkiyar rana.

Hakanan akwai yanayin da ke faruwa lokacin da ake buƙata daga kwanan wata ɗaya don rage wani kuma ƙayyade banbanci tsakanin su a cikin kwanaki.

1. Sanya Halin "=" a cikin tantanin halitta inda za'a nuna sakamakon. Bayan haka, muna da yumɓu a kan takardar, inda ranar ta gaba ke ƙunshe. Bayan jawabinsa ya bayyana a cikin dabara, mun saita alamar "-". Yumbu a cikin tantanin halitta dauke da farkon kwanan wata. Sannan yumbu akan shiga.



2. Kamar yadda kake gani, shirin daidai ƙididdige yawan kwanakin tsakanin kwanakin da aka ƙayyade.

Hakanan, bambanci tsakanin kwanakin da za a iya ƙididdige amfani da aikin mafita. Yana da kyau saboda yana ba ku damar daidaita tare da taimakon ƙarin muhawara, a cikin waɗanne raka'a za a sami bambanci ga: watanni, kwanakin, da sauransu. Rashin kyawun wannan hanyar shine wannan aikin tare da ayyuka har yanzu yana da wahala fiye da tsari na al'ada. Bugu da kari, mai santa na soloti ya ɓace a cikin jerin maye, sabili da haka dole ne a gudanar da shi da hannu ta hanyar amfani da Syntax:

= Umurni (nach_data; kon_dat;

"Kwanan baya" hujja ce, wacce take farkon kwanan wata ko tunani a kan kashi a kan takardar.

"Kwanan wata" gardama ne a cikin hanyar wani kwanan wata ko hanyar haɗi zuwa gare ta.

Mafi ban sha'awa hujja "daya". Tare da shi, zaku iya zaɓar zaɓi daidai yadda za'a nuna sakamakon. Ana iya daidaita shi ta amfani da ƙimar:

• "D" - An nuna sakamakon a cikin kwanaki;
• "M" - a cikin sa'a;
• "Y" - a cikin shekaru masu cikakken shekaru;
• "Yd" - wani bambanci a cikin kwanaki (ban da shekaru);
• "MD" wata bambanci ne a cikin kwanaki (ban da watanni da shekaru);
• "YM" shine bambanci a cikin watanni.

Don haka, a cikin yanayinmu, ya zama dole a lissafta bambancin a cikin kwanaki tsakanin Mayu 27 ga Maris, 2017. Wadannan kwanakin suna cikin sel tare da daidaitawa B4 da D4, bi da bi. Mun kafa siginan siginar a cikin wani abu mai komai, inda muke son ganin sakamakon lissafin, kuma rubuta wannan tsari mai zuwa:

= D4; b4; "d")

Mun danna Shigar kuma mun sami sakamakon ƙarshe na lissafin banbanci 74. Lallai ne, tsakanin waɗannan kwanakin ya ta'allaka ne 74 kwana.

Idan ya zama dole a cire kwanakin, amma ba tare da shiga cikin sel na takardar, to, a wannan yanayin muna amfani da wannan tsari:

= OTTES ("03/14/2017"; "27.05.2017"; "d")

Shake da maballin shigar. Kamar yadda muke gani, sakamakon yana da dabi'a iri ɗaya, kawai samu dan kadan ta wata hanyar.

Darasi: Yawan ranakun tsakanin kwanakin da aka samu a eccele

Hanyar 4: Lokaci

Yanzu mun kusanci nazarin da algorithm don rage lokacin rage lokacin da ya fito a cikin Excelle. Babban mizanin ya kasance iri ɗaya kamar lokacin da aka rage kwanakin. Kuna buƙatar ɗaukar farkon daga baya.

1. Don haka, muna fuskantar aikin neman adadin mintina nawa ne daga 15:13 zuwa 22:55. Muna rubuta waɗannan dabi'un lokacin zuwa sel daban a kan takardar. Abin da ke ban sha'awa, bayan shigar da bayanai, za a tsara hanyoyin takardar ta atomatik a ƙarƙashin abin da ke ciki idan ba su tsara ba. A cikin kishili, dole ne su tsara a ƙarƙashin kwanan nan. A waccan tantanin, a cikin abin da aka nunawa za'a nuna shi, mun sanya halayyar "=". Sannan muna murkushe wani abu mai dauke da wani lokaci (22:55). Bayan an nuna adireshin a cikin tsari, mun shiga halin "-". Yanzu muna da yumbu akan wani sashi a cikin abin da farkon lokacin yake (15:13). A cikin lamarinmu, da dabara na fom:

   = C4-e4

   To clay yumbu akan shiga.



2. Amma, kamar yadda muke gani, an nuna sakamakon kadan ba a cikin hanyar da muke so ba. Muna bukatar banbanci kawai a cikin mintuna, kuma an nuna 7 hours 42.

   Don samun minti daya, muna bin sakamakon da ya gabata don ninka ta hanyar daidaito ta 1440. Wannan ingantaccen inganci ya samo yawan mintina a cikin awa daya (24).

Don haka, saita alamar "=" a cikin tantanin komai a kan takarda. Bayan haka, muna samar da danna wancan siginar na takardar, inda bambanci a cikin lokaci a cikin lokaci yake (7:42). Bayan daidaitawar wannan sel aka nuna a cikin dabara, danna kan "ninka" alama (*) a kan keyboard, sannan kuma ka kuma karba sakamakon 1440. Don karbar sakamakon 1440. Don karbar sakamakon 1440. Don karbar sakamakon 1440. Don karbar sakamakon 1440. Don karbar sakamakon 1440. Don karbar sakamakon 1440. Don karbar sakamakon 1440. Don karbar sakamakon 1440. Don karbar sakamakon 1440. Don karbar sakamakon lãka.



3. Amma, kamar yadda muke gani, sake faruwa ba daidai ba (0:00). Wannan ya faru ne saboda gaskiyar cewa lokacin da za a ƙara ƙwayar ganye ta atomatik a cikin tsarin lokaci. Don yin bambanci a cikin minti, muna buƙatar dawo da tsarin gaba ɗaya.



4. Don haka, muna ware wannan tantanin halitta da "gida" ta yumbu a kan Triangle Triangle zuwa gare mu zuwa dama filin nuni filin nuni. A cikin jerin kunnun, zaɓi zaɓi na "Janar".

   

   Kuna iya shigar da daban. Zaɓi ƙayyadadden takardar ƙayyadaddun kuma danna maɓallan Ctrl + 1. An ƙaddamar da taga Tsarin taga wanda muka riga muka yi ma'amala da farko. Matsar cikin shafin "lamba" kuma a cikin jerin lambobin lambobi, zaɓi "Janar" zaɓi. Yumbu a "Ok".



5. Bayan amfani da kowane ɗayan waɗannan bambance-bambancen, tantanin halitta yana cikin tsari gaba ɗaya. Yana nuna bambanci tsakanin lokacin da aka ƙayyade a cikin minti. Kamar yadda kake gani, bambanci tsakanin 15:13 da 22:55 minti 462.

Darasi: Yadda za a fassara agogo a cikin mintuna a fice

Kamar yadda muke gani, abubuwa na kirga bambanci cikin fice sun dogara da yadda mai amfani yake aiki tare da tsarin bayanai. Amma, duk da haka, babban ƙa'idar kusanci zuwa wannan matakin ilmin lissafi ba ya canzawa. Wajibi ne a cire daban-daban daga lamba daya. Wannan yana kulawa don cimma tare da tsarin ilimin lissafi waɗanda aka yi amfani da su bisa tsarin Exceler Excel, da kuma amfani da ayyukan da aka saka hannu.