Okuqukethwe
Indlela elula
Khetha ububanzi obunamadethi eshidini bese ukhetha kuthebhu Ikhaya - Ukufometha Okunemibandela - Imithetho Yokukhetha Iseli - Usuku (Ikhaya - Ukufometha Okunemibandela - Gqamisa Imithetho Yeseli - Idethi Eyenzekayo). Ewindini elivulayo, khetha inketho yokukhanyisa oyifunayo ohlwini lokudonsela phansi:
Indlela enzima kodwa enhle
Manje ake sihlaziye inkinga ibe nzima nakakhulu futhi iyathakazelisa. Ake sithi sinetafula elikhulu lezimpahla ezithile:
Sicela uqaphele idethi yokuthunyelwa. Uma kungokwedlule, kusho ukuthi izimpahla sezilethiwe - akumele ukhathazeke. Uma kusesikhathini esizayo, kufanele sigcine udaba lulawulwa futhi singakhohlwa ukuhlela ukulethwa ngedethi eshiwo. Futhi ekugcineni, uma usuku lokuthunyelwa luqondana nolwanamuhla, khona-ke udinga ukulahla yonke into futhi ubhekane naleli qoqo elithile okwamanje (okubaluleke kakhulu).
Ukuze uthole ukucaca, ungasetha imithetho emithathu yokufometha enemibandela ukuze ugcwalise ngokuzenzakalelayo wonke ulayini ngedatha yenqwaba ngemibala ehlukene kuye ngedethi yokuthunyelwa. Ukuze wenze lokhu, khetha itafula lonke (ngaphandle kweheda) bese ukhetha kuthebhu Ikhaya - Ukufometha Okunemibandela - Dala Umthetho (Ikhaya - Ukufometha Okunemibandela - Dala Umthetho). Ewindini elivulayo, setha uhlobo lomthetho wokugcina Sebenzisa ifomula ukuze unqume ukuthi yimaphi amaseli ozofometha (Sebenzisa ifomula ukuze unqume ukuthi yiliphi iseli ozofometha) bese ufaka ifomula elandelayo ensimini:
Le fomula ithatha okuqukethwe kwamaseli E5, E6, E7… ngokulandelana ukusuka kukholomu yedethi yomkhumbi futhi iqhathanisa leyo dethi nedethi yanamuhla kuseli C2. Uma idethi yokuthunyelwa ingaphambi kwanamuhla, khona-ke ukuthunyelwa sekuvele kwenzeka. Qaphela izimpawu zedola ezisetshenziselwa ukumisa izixhumanisi. Ireferensi ku-$C$2 kufanele iphelele - ibe nezimpawu zamadola amabili. Ireferensi yeseli yokuqala yekholomu enedethi yokuthunyelwa kufanele ibe nokulungisa ikholomu kuphela, kodwa hhayi umugqa, okungukuthi $E5.
Ngemva kokufaka ifomula, ungasetha umbala wokugcwalisa nowefonti ngokuchofoza inkinobho Framework (Ifomethi) bese usebenzisa umthetho wethu ngokuchofoza inkinobho OK. Bese uphinda yonke inqubo ukuze uhlole ukulethwa nokudiliva okuzayo kosuku lwamanje. Kumaqoqo athunyelwe, isibonelo, ungakhetha okumpunga, kuma-oda wesikhathi esizayo - okuluhlaza okotshani, nokwanamuhla - okubomvu okuphuthumayo:
Esikhundleni sedethi yamanje, ungafaka umsebenzi kuseli C2 NAMUHLA (NAMUHLA), okuzobuyekeza idethi isikhathi ngasinye lapho ifayela livulwa, elizobuyekeza ngokuzenzakalelayo imibala ekuthebula.
Uma ukukhanya okunjalo kungadingeki ngaso sonke isikhathi, kodwa kuphela isikhathi esithile sokusebenza netafula, khona-ke ungakwazi ukwengeza uhlobo lokushintsha kulokho osekwenziwe kakade. Ukuze wenze lokhu, vula ithebhu Unjiniyela (Unjiniyela). Uma ingabonakali, qala uyivule Ifayela – Izinketho – Enza ngendlela oyifisayo iribhoni Bese uqhafaza Faka (Faka):
Ohlwini lwamathuluzi avulekayo, khetha Ibhokisi lokuhlola (Ibhokisi lokuhlola) kusukela kusethi ephezulu Izilawuli zefomu bese uchofoza endaweni eseshidini ofuna ukuyibeka kuyo. Ngemuva kwalokho ungabeka usayizi wombhalo bese ushintsha umbhalo wawo (chofoza kwesokudla - Shintsha umbhalo):
Manje, ukuze usebenzise ibhokisi lokuhlola ukuze uvule noma uvale okugqamile, udinga ukukuxhuma kunoma iyiphi iseli eshidini. Chofoza kwesokudla ebhokisini lokuhlola elidwetshiwe bese ukhetha umyalo kumenyu yokuqukethwe Ifomethi Yento (Into Yefomethi) bese kuthi efasiteleni elivulekayo, usethe noma iyiphi iseli efanelekile ensimini Ukuxhumana kwamaselula (Isixhumanisi Seseli):
Hlola ukuthi konke kusebenza kanjani. Iseli E2 exhunyiwe kufanele ikhiphe TRUE uma ibhokisi lokuhlola linikwe amandla, noma FALSE uma likhutshaziwe.
Manje kusele ukungeza umthetho owodwa ekufometheni okunemibandela ukuze ibhokisi lethu lokuhlola livule futhi livale ukugqama kwedethi. Khetha ithebula lethu lonke (ngaphandle kweheda) bese ulivula kuthebhu Ikhaya - Ukufometha Okunemibandela - Phatha Imithetho (Ikhaya - Ukufometha Okunemibandela - Phatha Imithetho). Efasiteleni elivulekayo, imithetho esiyidalile ngaphambili yokugqamisa amadethi esikhathi esedlule, esizayo nezamanje ngemibala ehlukene kufanele ibonakale ngokucacile:
Cindezela inkinobho Dala Umthetho (Umthetho Omusha), khetha uhlobo lomthetho wokugcina Sebenzisa ifomula ukuze unqume ukuthi yimaphi amaseli ozofometha (Sebenzisa ifomula ukuze unqume ukuthi yiliphi iseli ozofometha) bese ufaka ifomula elandelayo ensimini:
Asisethi ifomethi bese sichofoza OK. Umthetho odaliwe kufanele wengezwe ohlwini olujwayelekile. Manje udinga ukuyiphakamisela kulayini wokuqala ngemicibisholo (uma ingekho) bese uvule ibhokisi lokuhlola elibhekene nalo kwesokudla. Yeka uma kuyiqiniso (Yeka Uma Iqiniso):
Ipharamitha enegama elingacacile Yeka uma kuyiqiniso wenza into elula: uma umthetho omelene nawo uyiqiniso (okungukuthi ifulege lethu Ukugqamisa umugqa wesikhathi eshidini livaliwe), bese iMicrosoft Excel imisa ukuqhubeka kwemithetho, okungukuthi ayithuthukeli emithethweni elandelayo ohlwini lokufometha olunemibandela futhi ayigcwali etafuleni. Okuyikhona okudingekayo.
- Ukufometha okunemibandela ku-Excel 2007-2013 (ividiyo)
- Idube imigqa yetafula enemigqa
- I-Excel isebenza kanjani ngempela namadethi nezikhathi