Excel Kusiyana: Njira 4 zosavuta

Kuwerengera kwa kusiyana ndi chimodzi mwazinthu zotchuka kwambiri mu masamu. Koma kuwerengera kumeneku sikugwiritsidwa ntchito osati sayansi. Nthawi zonse timazichita, osaganiza, ndipo tsiku ndi tsiku. Mwachitsanzo, kuti muwerengere kuperekera kugula m'sitolo, imagwiritsidwanso ntchito kuwerengera kusiyana pakati pa ndalama zomwe wogulayo adapereka wogulitsa, ndi mtengo wa katundu. Tiyeni tiwone momwe mungawerengere kusiyana kwa Excel mukamagwiritsa ntchito mawonekedwe osiyanasiyana a data.

Kuwerengera kusiyana

Poganizira za izi zapamwamba ndi mitundu yosiyanasiyana ya deta, pochotsa mtengo umodzi kuchokera kwina, mitundu yosiyanasiyana ya formula imagwiritsidwa ntchito. Koma ambiri, chilichonse chitha kuchepetsedwa kukhala mtundu umodzi:

X = A-B

Ndipo tsopano tiyeni tiwone momwe zomwe zimakhalira zosiyanasiyana zimanyamulidwa: zambiri, ndalama, masiku ndi nthawi.

Njira 1: Kuphatikiza manambala

Nthawi yomweyo tiyeni tikambirane mitundu yomwe imagwiritsidwa ntchito kwambiri powerengera kusiyana kwa kusiyana kwake, ndiye kuchotsedwa kwa ma emeric mfundo. Pazifukwa izi, masamu wamba okhala ndi chizindikiro "-" angagwiritsidwe ntchito.

Ngati mukufunikira kuti mupange zomwe zimapangitsa kuti muthe kuzithandizira pogwiritsa ntchito Excel, monga chowerengera, kenako ikani chithunzi cha "=" mu cell. Kenako zitachitika chizindikiritsochi, nambala yotsika kuchokera pa kiyibodi iyenera kujambulidwa, ikani chizindikirocho kuti "-, kenako jambulani kuchotsera. Ngati mukuchotsedwa, ndiye kuti muyenera kuyika chizindikiro cha "-" ndikujambulitsanso nambala yomwe mukufuna. Njira yosinthira chizindikiro cha masamu ndi manambala ziyenera kuchitika mpaka zofukizira zonse zikalowe. Mwachitsanzo, kuchokera pakati pa 10 kuchotsera 5 ndi 3, muyenera kulemba njira zotsatirazi
= 10-5-3.
Pambuyo polemba mawu, kuti muchepetse chifukwa cha kuwerengera, dinani batani la Enter.

Manambala othandizapo mu Microsoft Excel

Monga mukuwonera, zotsatira zake zidawonekera. Ndizofanana ndi nambala 2.

Zotsatira zakuchotsa manambala ku Microsoft Excel

Koma makamaka nthawi zambiri zopukutira zomwe zimachitika pakupambana zimagwiritsidwa ntchito pakati pa manambala omwe adayikidwa m'maselo. Nthawi yomweyo, algorithm ya masamu sizisintha, pokhapokha ngati pali matchulidwe, maulalo omwe amagwiritsidwa ntchito, komwe amakhala. Zotsatira zimawonetsedwa mu gawo lina la pepalalo, komwe mawonekedwewo "=" amaikidwa.

Tiyeni tiwone momwe mungawerengere kusiyana pakati pa manambala 59 ndi 26, yomwe ili mu zinthu za pepalali ndi magwiridwe antchito a A3 ndi C3.

Sankhani chinthu chopanda kanthu cha buku lomwe tikukonzekera kuwonetsa zotsatira za kuwerengetsa kusiyana kwa kusiyana kwake. Tidayika m'chifaniziro "=". Pambuyo pake, dinani pa cell A3. Timayika chizindikiro chakuti "-". Kenako, timakhala ndi disdina gawo la pepala la C3. Fomu yotsatirayi iyenera kuwonekera mu gawo la pepalalo kuti lituluke:
= A3-C3
Monga momwe zidayambira kale, kuwonetsa zotsatira pazenera, dinani batani la Enter.

Fomu Yochotsa manambala omwe ali mu matchalitchi a Microsoft Excel

Monga tikuwona, pankhaniyi kuwerengera kunachitika bwino. Zotsatira zowerengera ndizofanana ndi nambala 33.

Zotsatira zakuchotsa manambala zomwe zili mu maselo mu Microsoft Excel

Koma makamaka, nthawi zina, ndikofunikira kuti mumvetsetse zomwe angatenge, zonse ziwiri zigwirizane ndi malumikizidwe kwa maselo omwe ali. Chifukwa chake, mawuwo, mwachitsanzo:

= A3-23-C3-E3-5

Kuzimitsa manambala ndi maulalo a maselo okhala ndi manambala amodzi mu Microsoft Excel

Phunziro: Momwe mungasinthire chiwerengerocho kuchokera kwa Eale

Njira 2: Mtundu wandalama

Kuwerengera kwa mfundo mu ndalama sikusiyana ndi kuchuluka. Njira zomwezo zimagwiritsidwa ntchito, kuyambira, ndi akulu, mawonekedwe awa ndi amodzi mwazosankha. Kusiyanako kumatsala pang'ono kuti kumapeto kwa zofunikira pakuwerengera ndalama, chizindikiro cha ndalama za ndalama zinakhazikitsidwa.

Kwenikweni, mutha kuchitidwa opaleshoni monga kuchotsera kwaumwini kwa manambala, ndipo pokhapokha ngati zimapangitsa kuti zotsatira zomaliza zizichita ndalama. Chifukwa chake, timapanga kuwerengera. Mwachitsanzo, adzachotsa pa 15th 3.

Pambuyo pake, dinani pa chinthucho, chomwe chili ndi zotsatira zake. Pamenyu, sankhani mtengo wa "Fomu ya Cell ...". M'malo mongotchula menyu, mutha kufunsa pambuyo posankha makiyi a Ctrl + 1.

Kusintha kwa mtundu wa maselo kudzera mu menyu mu Microsoft Excel

Ndi zina mwazomwe zatchulidwazi, zenera lokonzedwa limayambitsidwa. Pitani mu gawo la "nambala". Mu "mitundu ya manambala" imadziwika kuti "ndalama". Nthawi yomweyo, minda yapadera imawonekera kumbali yakumanja kwa mawonekedwe a zenera, momwe mungasankhire mtundu wa ndalama ndi chiwerengero cha zizindikiro za dernal. Ngati muli ndi mawindo okwanira ndi Microsoft Office, makamaka, omwe amakhala ku Russia, ndiye kuti sangakhale chizindikiro chokhazikika, komanso chizindikiritso cha zizindikiro za dertible, 2 ". M'matangano ambiri, makondawa siofunikira. Koma, ngati mukufunikirabe kuwerengera mu madola kapena popanda zizindikiro zanzeru, ndikofunikira kusintha zina.
Kutsatira momwe kusintha kulikonse kumapangidwira, dongo pa "Chabwino".

Kukhazikitsa mtundu wa ndalama muzenera ku Microsoft Excel

Monga tikuwonera, chifukwa cha zopatanira mu cell idasinthidwa kukhala mtundu wokhala ndi zizindikiro za decomial.

Palinso njira ina yopangidwira kuti ichotse chotsani ndalama. Kuti muchite izi, muyenera dinani pa nthiti "kunyumba" pa makona atatu omwe ali kumanja kwa gawo la mawonekedwe a cell apano mu "nambala" chida. Kuchokera pamndandanda woyamba, sankhani "ndalama". Makhalidwe a manambala adzasinthidwa kukhala ndalama. Zowona, pankhaniyi, palibe kuthekera kosankha ndalama ndi chiwerengero cha zizindikiro za dermal. Chosiyanasiyana chomwe chimakhazikitsidwa mu dongosolo lokhazikika, kapena chimakonzedwa kudzera pawindo lojambulidwa pamwambapa.

Kukhazikitsa mtundu wa ndalama kudzera mu chipangizo cha tepi ku Microsoft Excel

Ngati mungawerenge kusiyana pakati pa mfundo zomwe zili m'maselo omwe amakonzedwa kale kuti mupeze ndalama, ndiye kuti gawo la tsamba lotulutsa sichofunikira. Idzapangidwa modekha pansi pa mawonekedwe oyenera pambuyo pa formula ikalowetsedwa ndi maulalo ku zinthu zomwe zimakhala ndi ziwerengero zochepetsedwa komanso zosakanizidwa, komanso dinani pa kiyi ya Enter.

Mtundu wa ndalama mu khola zotsatira za kuwerengera kwa kusiyana kwa Microsoft Excel

Phunziro: Momwe Mungasinthire Mtundu wa Maseri Kupambana

Njira 3: Madeti

Koma kuwerengetsa kwa masikuwo kumathandizanso kuposa zosankha zakale.

Ngati tikufuna kuthana ndi masiku angapo kuchokera tsiku lomwe latchulidwa mu gawo limodzi la zinthu zomwe zili pa pepalalo, ndiye kuti zoyambirira zimakhazikitsa chinthucho pomwe zotsatira zomaliza zidzawonetsedwa. Pambuyo pake, dinani pa chinthucho, komwe tsiku lili. Adilesi yake idzawonetsedwa mu chinthu chotulutsa komanso mu chingwe. Kenako, timakhazikitsa chizindikiro chakuti "-" ndikuyendetsa masiku ochokera m kiyibodi yomwe muyenera kuchotsera. Pofuna kuwerengera dongo pa ENTER.

Kufupa Folala kuchokera tsiku la kuchuluka kwa masiku angapo ku Microsoft Excel

Zotsatira zake zimawonetsedwa mu khungu lopangidwa ndi ife. Pankhaniyi, mawonekedwe ake amangosinthidwa kukhala mtundu wa tsiku. Chifukwa chake, timapeza tsiku lodzala.

Zotsatira zakuchotsa kuyambira tsiku la masiku angapo ku Microsoft Excel

Palinso zochitika zam'manja zikafunika kuchokera tsiku limodzi kuti athe kulolana wina ndi kuzindikira kusiyana pakati pawo m'masiku.

Ikani mawonekedwe "=" m'selo pomwe zotsatirapo zake zidzawonetsedwa. Pambuyo pake, tili ndi dongo pazinthu za pepalalo, pomwe tsiku lomaliza limapezeka. Adilesi yake itawonekera mu fomula, timakhazikitsa chizindikiro "-". Dongo mu khungu lomwe lili ndi tsiku loyambirira. Kenako dongo ku Enter.

Formula yowerengera kusiyana kwa masikuwo mu Microsoft Excel

Monga mukuwonera, pulogalamuyo imawerengetsa bwino kuchuluka kwa masiku pakati pa masiku omwe atchulidwa.

Kusiyana pakati pa masiku awiri ku Microsoft Excel

Komanso, kusiyana pakati pa masiku kumatha kuwerengedwa pogwiritsa ntchito njira yothetsera yankho. Ndizabwino chifukwa zimakupatsani mwayi wokonza mothandizidwa ndi mfundo ina, yomwe magawo adzachotsedwa: miyezi, masiku, etc. Zovuta za njirayi ndikugwira ntchito ndi ntchito zomwe zimakhala zovuta kwambiri kuposa momwe zimakhalira ndi njira zachikhalidwe. Kuphatikiza apo, wogwiritsa ntchito solite akusowa pamndandanda wa nkhamba za nezard, chifukwa chake iyenera kuperekedwa pamanja pogwiritsa ntchito syntax:

= Malamulo (nach_data; kon_dat;

"Tsiku Loyamba" ndi mkangano, womwe ndi tsiku loyambirira kapena lotchulira, lomwe lili pazinthu papepala.

"Tsiku lomaliza" ndi mkangano wa tsiku lotsatira kapena lolumikizani.

Mfundo yosangalatsa kwambiri "imodzi". Ndi izi, mutha kusankha njirayi momwe zotsatirazi zidzawonetsedwa. Itha kusintha pogwiritsa ntchito mfundo zotsatirazi:

"D" - zotsatira zake zikuwonetsedwa m'masiku;
"M" - m'miyezi yathu;
"Y" - mu zaka zathunthu;
"YD" - kusiyana m'masiku (kupatula zaka);
"MD" ndi kusiyana m'masiku (kupatula miyezi ndi zaka);
"YM" Kodi pali kusiyana m'miyezi.

Chifukwa chake, kwa ife, ndikofunikira kuwerengera kusiyana kwa masiku pakati pa Meyi 27 ndi pa Marichi 14, 2017. Madeti awa amapezeka m'maselo a B4 ndi D4, motero. Timakhazikitsa cholembera mu chinthu chilichonse chopanda kanthu, pomwe tikufuna kuwona zotsatira za kuwerengera, ndikulemba njira zotsatirazi:

= D4; B4; "D")

Timadina kulowa ndikupeza zotsatira zomaliza za kuwerengetsa kwa kusiyana kwa 74. Zowonadi, pakati pa masiku awa pali masiku 74.

Zotsatira za kuwerengera ntchito ya anthu ammudzi ku Microsoft Excel

Ngati ndikofunikira kuti muchepetse madeti omwewo, koma osalowa m'maselo a pepalalo, ndiye kuti pankhaniyi timagwiritsa ntchito njira yotsatirayi:

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

Gwedezaninso batani lolowera. Monga tikuwona, zotsatira zake zimakhala zofanana, zimangopezeka pang'ono m'njira ina.

Zotsatira za kuwerengetsa ntchito zamalamulo ku Microsoft Excel

Phunziro: Chiwerengero cha masiku pakati pa masiku onse

Njira 4: Nthawi

Tsopano tinayandikira kuphunzira kwa algorithm pofuna kuchotsa nthawi yambiri. Mfundo yayikulu idali yofanana ndi yofuula. Muyenera kuchotsa molawirira kuyambira nthawi ina.

Chifukwa chake, tikuyenera kugwira ntchito yopeza mphindi ingapo kuyambira 15:13 mpaka 22:55. Timalemba nthawi izi mu maselo osiyana papepala. Chosangalatsa, mutalowetsedwa deta, masamba ake apangidwa okha malinga ndi zomwe zili mkati mwa zomwe asapangidwe kale. Mosakayikira, ayenera kukhala ndi mtundu watsikulo pamanja. Mu khungu limenelo, momwe zotsatira za kuchotsera ziwonekere, timayika mawuwo "=". Kenako timalimbikitsa gawo lomwe lili ndi nthawi yotsatira (22:55). Adilesi ikawonetsedwa mu fomula, timalowa mkhalidwe "-". Tsopano ndife dongo pa pepala lomwe nthawi yoyambirira ili (15:13). Kwa ife, njira ya mawonekedwe:
= C4-e4
Kuwerengera dongo la Enter.

Nthawi yowerengera mawonekedwe mu Microsoft Excel

Koma, monga tikuwona, zotsatirapo zake zidawonetsedwa pang'ono osati momwe tinkafunira. Tinafunikira kusiyana kokha mumphindi chabe, ndipo idawonetsedwa maola 7 mphindi 42.
Kuti tipeze miniti, timatsata zotsatira zapitayo kuti tichulukitse 1440. Izi zimapezeka ndikuchulukitsa kuchuluka kwa mphindi (60) ndi maola m'masiku (24).

Chifukwa chake, khazikitsani "=" chizindikiro mu khungu lopanda kanthu pa pepalalo. Pambuyo pake, timapanga dinani pa chinthucho, pomwe kusiyana kwanyengo komwe kumathandizira nthawi yayitali (7:42). Pambuyo pazogwirizana za khungu ili zinkawonetsedwa mu formula, dinani pa "Kuchulukitsa"

Njira yomasulira foni yam'mphepete mwa miniti microsoft exros

Koma, monga tikuwona, zotsatirapo zake zidawonekera molakwika (0:00). Izi ndichifukwa chakuti pochulukitsa tsamba la tsamba lidasinthidwa zokha mu mtundu. Pofuna kusintha mphindi, tiyenera kubwezeretsanso mtundu wake.

Zotsatira zake zidawonekera molakwika mu Microsoft Excel

Chifukwa chake, timagawanelo ndikuti "kunyumba" tati ndi dongo pazomwe mumazolowera kupita kumanja kwa munda wowonekera. M'ndandanda wokhazikitsidwa, sankhani "General".

Mutha kulowa mosiyanasiyana. Sankhani gawo lotchulidwa ndikusindikiza Ctrl + 1 makiyi. Mawindo opanga mawonekedwe amayambitsidwa ndi zomwe tachita kale ndi kale. Lowani mu "nambala" ndi mndandanda wa mitundu ya manambala, sankhani "General". Dongo pa "chabwino".

Kutembenuka kwa maselo kupita ku mtundu wamba pogwiritsa ntchito zida zawindo ku Microsoft Excel

Mukatha kugwiritsa ntchito chilichonse mwa mitundu iyi, foni imasinthidwa mwanjira inayake. Zimawonetsa kusiyana pakati pa nthawi yodziwika mu mphindi. Monga mukuwonera, kusiyana pakati pa 15:13 ndi 22:55 kuli mphindi 462.

Kusiyana pakati pa nthawi mpaka microsoft Excel

Phunziro: Momwe mungamasulire wotchi munthawi yopambana

Monga tikuwona, kuwerengera kuwerengetsa kusiyana kwa excel kumadalira momwe wogwiritsa ntchito amagwirira ntchito ndi mawonekedwe a data. Koma, komabe, mfundo yayikulu yoyandikira masamu izi sizisintha. Ndikofunikira kuti muchepetse osiyanasiyana ndi nambala imodzi. Izi zimatha kukwaniritsa ndi njira zomwe zimagwiritsidwa ntchito malinga ndi sylcl syntax, komanso pogwiritsa ntchito ntchito zophatikizika.