01 ngo 01
I-Excel Shading Rows / Iikholam zeFomula
Ininzi yexesha, ukufomathiza okunemeko kusetyenziswa ukutshintsha imibala yeselk okanye imibala yempendulo ekuphenduleni idatha efakwe kwiseli efana nomhla ongadluliyo okanye inkcitho yebhajethi ephakamileyo, kwaye ngokuqhelekileyo oku kwenziwa ngokusebenzisa iimeko ze-Excel zangaphambili.
Ukongeza kwizinto ezikhethwe ngaphambili, nangona kunjalo, kunakho ukudala imithetho yokwenza ifomathi enemeko esebenzayo usebenzisa iifomula ze-Excel ukuvavanya izimo ezichazwe ngumsebenzisi.
Enye ifom ifom edibanisa imisebenzi ye- MOD ne- ROW , ingasetyenziselwa ukuthutha ngokuzenzekelayo imiqolo yedata engenza ukuba kufundwa kwedatha kumaphepha amakhulu okusebenzela , kulula kakhulu.
Shading Dynamic
Enye inzuzo ekusebenziseni ifomula yokongeza umthunzi womhlathi kukuba u-shading unamandla kwaye uthetha ukuba utshintshe ukuba inani lemiqolo litshintsha.
Ukuba imigqa ingeniswa okanye isuswe u-shading umugqa ulungele ngokwayo ukuze ugcine umzekelo.
Qaphela: Imigqa engafaniyo yodwa yindlela yokukhetha kunye nale fomyula. Ngokuyitshintsha kancane, njengoko kuchaziwe ngezantsi, ifomula inokuthungela nayiphina imodeli yemiqolo. Ingasetyenziselwa ukuthunjwa iikholomu endaweni yemigca xa ukhetha.
Umzekelo: Ukwabelana ngeeFormula zeFomula
Isinyathelo sokuqala kukugqamisa uluhlu lweeseli ukuba lufakwe emthunjini kuba ifom ifuthe kuphela kula maseli akhethiweyo.
- Vula iphepha lokusebenzela lase-Excel-iphepha lokusebenzela elingenanto liya kusebenza kule khokelo
- Phakamisa uluhlu lweeseli kwiphepha lokusebenzela
- Cofa kwiThebhu yasekhaya yerbhoni
- Cofa kwi icon Yokwenza Ifomathi yokuzibophelela ukuvula imenyu ehlayo
- Khetha inketho entsha yolawulo ukuvula ibhokisi yencoko yebhokisi yencoko yokuHlaziya
- Cofa kwiSebenzi yeFomula ukukhetha ukuba yeyiphi iiseli ukufomatha ukhetho kwiluhlu oluphezulu kwibhokisi yencoko
- Faka le fomyula elandelayo kwibhokisi engezantsi kwiimpawu zokufometha apho eli xabiso linyaniso okwenyaniso kwisigqibo esingaphantsi kwibhokisi yencoko = IMOD (ROW (), 2) = 0
- Cofa iqhosha lokuFometha ukuvula ibhokisi yencoko yebhokisi yefomathi
- Cofa u Gcwalisa ityhubhu ukubona imbala yendawo yombala
- Khetha umbala ozowusebenzisa ukuze uhlambele eminye imigqa yoluhlu olukhethiweyo
- Cofa Kulungile kabini ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela
- Imigca engafani kwibala ekhethiweyo kufuneka ngoku i-shaded kunye nombala okhethiweyo wesiqhelo
Ukutolika iFormula
Indlela le fomyula efundwa yi-Excel yile:
- Inombolo yesi-2 kwindlela ibonisa ukuba iphethini ye-shading liphinda umqolo ngamnye wesibini kwibanga elikhethiweyo
- imeko ye = 0 kwi-formula ibonisa ukuba umgca wokuqala kwibala alunamthunzi - okwenziweyo ngenxa yokuba lo mgca uhlala uqulethe izihloko ezifomathiweyo.
Yiyiphi i-MOD ne-MAN
Umzekelo uxhomekeke kwimisebenzi ye-MOD kwifom. Yintoni eyenziwa yi-MOD ihlula inombolo yomqolo (echithwe ngumsebenzi we-ROW) ngenombolo yesibini ngaphakathi kubakaki kwaye ubuyisela intsalela okanye i-modulus njengoko kuthiwa ngezinye iixesha.
Kule ngongoma, ukufomathika kwemiqathango kuthatha kwaye kuthelekisa i modyuli ngenani emva kokusayina okulinganayo. Ukuba kukho umdlalo (okanye ngaphezulu ngokuchanekileyo ukuba le meko iyinyaniso), lo mgca unomthunzi, ukuba amanani akweliphi na icala lomqondiso olinganayo ahambelani, loo mqathango uFALSE kwaye akukho mthunzi owenzeka kuloo mgca.
Ngokomzekelo, kumfanekiso ongentla, xa umgca wokugqibela kwicandelo elikhethiweyo eli-18 lihlulwe ngo-2 ngumsebenzi we-MOD, intsalela ngu-0, ngoko imeko ye-0 = 0 yiYENYANISO, kwaye umgca ugocekile.
I-Row 17, ngakolunye uhlangothi, xa ulwahlulwe ngo-2 ushiya intsalela ye-1, engalinganiyo 0, ngoko umgca ushiyekile.
Iikholam zeShawuneni endaweni yeeNdlo
Njengoko kuthethwe ngazo, iifomula ezisetyenziselwa ukuthungqa imigqa enye ingatshintshwa ukuze zivumele iikholeji ze-shading ngokunjalo. Utshintsho olufunekayo kukusebenzisa umsebenzi we-COLUMN esikhundleni somsebenzi we-ROW kwifomu. Ngokwenza njalo, i-formula ibonakala ngathi:
= IMOD (COLUMN (), 2) = 0Qaphela: Utshintsho kwifom ye-shading ifom yokuguqula umzekelo we-shading ochazwe ngezantsi usetyenziswa kwimfomula ye-shading.
Shintsha ifomula, Shintsha i-Pattern Shading
Ukutshintsha umzekelo we-shading kwenziwa lula ngokutshintsha nokuba yeyiphi na manani amabini kwifom.
- Ukuba u-shading row uqale ngomqolo wokuqala endaweni yesibini, ekupheleni kwefomyula, tshintsha = 0 ukuya = 1 ;
- Ukuze ube nomgca wesithathu okanye wesine umthunzi esikhundleni semigqa eminye, tshintsha i-2 kwifomula ukuya ku-3 okanye kwi-4.
Ulwahlulo alukwazi ukuba yiZero okanye enye
Inani ngaphakathi kubakaki libizwa ngokuba ngumcebisi kuba liyinombolo ekwahlula kwimisebenzi ye-MOD. Ukuba ukhumbule emva kweklasi yezibalo ezahlukana yi-zero akuvumelekanga kwaye akuvumelekanga kwi-Excel nokuba. Ukuba uzama ukusebenzisa i-zero ngaphakathi kubakaki endaweni ye-2, njengale:
= IMOD (ROW (), 0) = 2awuyi kufumana umthunzi kuyo yonke ibanga.
Ngaphandle koko, ukuba uzama ukusebenzisa inombolo enye kumcebisi ukuze i-formula ibonakale:
= IMOD (ROW (), 1) = 0ngamnye umqolo kwinqanaba liya kuthunjulwa. Oku kwenzeka ngenxa yokuba nayiphina inombolo eyahlula enye yashiya intsalela ye-zero, kwaye khumbula, xa imeko ye-0 = 0 iyinyaniso, lo mgca ugobile.
Shintsha uMqhubi, Shintsha i-Pattern Shading
Ukutshintsha ngokwenene ipateni, utshintshe umqathango okanye umatshini wokufanisa (uphawu olulinganayo) elisetyenziswe kwifomula ukuya kumqondiso ongaphantsi (<).
Ngokutshintsha = 0 ukuya <2 (ngaphantsi kwe-2) umzekelo, ezimbini iingqungquthela zidibeneyo zinokuthunjwa. Yenze loo <3, kwaye u-shading uza kwenziwa ngamaqela emigca emithathu.
I-caveat kuphela yokusebenzisa ngaphantsi komqhubi ukuqinisekisa ukuba inombolo ngaphakathi kubakaki inkulu kuneyo nombolo ekupheleni kwefomula. Ukuba akunjalo, ngamnye umgca kwicala liya kuthunjwa.