01 ngo 01
Fumana iNani elincinane kunazo zonke, ixesha elikhawulezayo, elifutshane kumgama, okanye umhla wokuqala
UMsebenzi woBuchule
Umsebenzi we-MIN uhlala ufumana inombolo encinci okanye encinane kwinani lexabiso, kodwa, ngokuxhomekeke kwidatha nendlela eyafomatha ngayo, ingasetyenziselwa ukufumana:
- ixesha elikhawulezayo;
- umgama omfutshane;
- ngejubane esezantsi;
- umhla wokuqala;
- e bushushu;
- imali encinci yemali.
Kwaye ngelixa kunzima ukukhetha ixabiso elikhulu kwinani elincinci le-integers, umsebenzi unzima kunzima kwixabiso elikhulu leenkcukacha okanye ukuba loo datha yenzeka:
- manani amabi;
- amaxesha alinganiselwe ngekhulu leesibini;
- Ixabiso lokutshintshwa kwemali libalwe kwiwaka elineshumi leminyaka;
- amanani afomathiweyo njengamaqhezu;
Imizekelo yamanani anjalo iboniswa kumfanekiso ongentla, kwaye ngelixa umsebenzi weM MIN ngokwawo ungatshintshi, ukuchaneka kwawo ekusebenzelaneni namanani kwiifom ezahlukeneyo kubonakala, kwaye esinye sezizathu zokuba umsebenzi uncedo gqitha.
UMsebenzi weSinta neSigxina
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, iibakaki, abahluli be-comma kunye neengxabano .
I-syntax yomsebenzi we-MIN ngu:
= MIN (Inombolo1, Inombolo2, ... Inani255)
Inani1 - (elifunekayo)
Inombolo2: Inombolo255 - (ngokuzikhethela)
Iingxoxo ziqulethe iinombolo eziza kukhangela ixabiso elikhulu-ukuya phezulu kuma-255.
Iingxoxo ziba:
- manani;
- zigaba ;
- iifayile;
- izikhokelo zeseli kwindawo yendawo kwiphepha lokusebenzela;
- Ixabiso leBoolean lifakwe ngqo kwiluhlu lweengxabano.
Amanqaku :
Ukuba iingxoxo aziqukethe amanani, umsebenzi uya kubuya ixabiso lentlawulo.
Ukuba uluhlu, uluhlu olukhankanyiweyo, okanye iselferensi yeseli esetyenziswe kwingxabano iqulethe:
- izisele ezingenanto;
- Ixabiso leBoolean;
- idatha yombhalo
ezo iiseli ziyanyanzelwa ngumsebenzi njengoko kuboniswe kumzekelo kumqolo 7 kumfanekiso ongentla.
Umqolo wesi-7, inombolo ye-10 kwiseli ye-C7 ifomathiweyo njengombhalo (phawula unxantathu oluhlaza elukhoneni eliphezulu ekhohlo leseli ebonisa ukuba inani ligcinwe njengombhalo).
Ngenxa yoko, kunye, kunye nexabiso le-Boolean (TRUE) kwiseli ye-A7 kunye ne-cell ye-B7 engenanto, ayinakunyulwa ngumsebenzi.
Ngenxa yoko, umsebenzi kwi-cell E7 ubuyisela i-zero impendulo, kuba u-A7 ukuya kwi-C7 ayiqukethe manani.
UMsebenzi woMsebenzi
Ingcaciso engezantsi iquka amanyathelo asetyenziswa ukufaka umsebenzi we-MIN kwiseli ye-E2 kumfanekiso ongentla. Njengoko kubonisiwe, uluhlu lweeferensi zeeseli luya kufakwa njengengxabano yenombolo yomsebenzi.
Enye inzuzo yokusebenzisa izithenxo zeselununu okanye uluhlu olukhankanyiweyo kukuba ukuba idatha ekutshintshelweni kwimiba, iziphumo zomsebenzi ziya kuhlaziywa ngokuzenzekelayo ngaphandle kokuba uhlele ifom ngokwayo.
Ukufaka i-MIN Function
Okukhethwa kukho ukungena kwifom kubandakanya:
- ukuthayipha ifom equlethe umsebenzi = MIN (A2: C2) ngqo kwi-cell E2 kwaye ucinezela ukungena kwekhibhodi;
- ukungena kwiingxoxo ngokusebenzisa ibhokisi yencoko yencoko ye MIN ;
- Ukusebenzisa isinqamulelo somsebenzi we-MIN esisekhompyutheni laseKhaya lebhebhoni .
Mfutshane Inkqubo yomsebenzi
Le ndlela emfutshane yokusebenzisa umsebenzi we-Excel ka-MIN ngenye yezinto ezininzi eziqhelekileyo ze-Excel ezineenkqutshane ezihlanganiswe phantsi kwe- AutoSum icon kwiTable yasekhaya yerbhoni.
Ukusebenzisa le ndlela emfutshane ukufaka umsebenzi we-MIN:
- Cofa kwifowuni E2 ukwenzela ukuba ibe yiseli esebenzayo
- Cofa kwiThebhu yasekhaya yerbhoni xa kuyimfuneko;
- Kwiphepha elide lasekunene lebhebhoni, nqakraza kwinqolo engezantsi kwicala le Σ AutoSum ukuvula uluhlu lwemisebenzi ephantsi;
- Cofa kwi-MIN kuloluhlu ukufaka umsebenzi we-MIN kwiseli ye-E2;
- Gqamisa iiseli ezi-A2 ukuya kwi-C2 kwiphepha lokusebenzela ukuze ufake olu luhlu njengengxabano yomsebenzi;
- Cinezela ukhiye wokungena kwikhibhodi ukugqiba umsebenzi;
- Impendulo -6,587,449 ibonakala kwiseli ye-E2, kuba yincinci encinane kunazo manani kule miqolo-engafanelekiyo iyancinci xa ivela kwi-zero;
- Ukuba ucofa kwiseli E2 umsebenzi opheleleyo = MIN (A2: C2) ibonakala kwifom yefomula ngaphezulu kwephepha lokusebenzela.