01 ngo 01
Fumana inani elikhulu kakhulu, ixesha elide kakhulu, umgama omde kakhulu, okanye ukushisa okuphezulu
Umsebenzi we-MAX uhlala ufumana inamba enkulu okanye enkulu kwinani lexabiso, kodwa, ngokuxhomekeke kwidatha nendlela eyafomatha ngayo, ingasetyenziselwa ukufumana:
- ixesha elincinci;
- umgama omde;
- ngejubane elikhawulezayo;
- umhla wokugqibela;
- iqondo lobushushu;
- inani elikhulu lemali.
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 we-MAX ungatshintshi, ukuchaneka kwawo ekusebenzelaneni namanani kwiifom ezahlukeneyo kubonakala, kwaye esinye sezizathu zokuba umsebenzi uncedo gqitha.
I-MAX Imisebenzi yeSintax kunye neArguments
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, iibakaki, abahluli be-comma kunye neengxabano .
I-syntax yomsebenzi we-MAX yile:
= MAX (Inani1, Inani2, ... 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 kwimpendulo, kuba u-A7 ukuya kwi-C7 ayiquki na manani.
Umsebenzi weeMiX
Ingcaciso engezantsi iquka amanyathelo asetyenziswa ukufaka umsebenzi we-MAX kwiseli ye-E2 kumzekelo womfanekiso ongentla. Njengoko kubonisiwe, uluhlu lweeferensi zeeseli luya kufakwa njengengxabano yenombolo yomsebenzi.
Enye inzuzo yokusebenzisa izithenxo zeeselfowuni okanye uluhlu oluchongiweyo oluchasene nokungena ngqo ngedatha kukuba ukuba idatha edityanisiweyo ishintsho, iziphumo zomsebenzi ziya kuhlaziywa ngokuzenzekelayo ngaphandle kokuhlela ifom ngokwayo.
Ukufaka umsebenzi we-MAX
Okukhethwa kukho ukungena kwifom kubandakanya:
- ukuthayipha ifom equkethe umsebenzi = Max (A2: C2) ngqo kwi-cell E2 kwaye ucinezela ukungena kwikhibhodi;
- ukungena kwiingxoxo ngokusebenzisa ibhokisi yencoko yencoko ye-MAX ;
- Ukusebenzisa isinqamlezo somsebenzi we-MAX esiseKhaya lithebhu yebhoni .
UMASX Umsebenzi ofutshane
Lo mnqamlezo wokusebenzisa umsebenzi we-Excel we-MAX ngenye yezinto ezininzi eziqhelekileyo ze-Excel ezineenkqutyana ezimfutshane ndawonye phantsi kwe-icon ye- AutoSum kwithebhu yasekhaya yerbhoni.
Ukusebenzisa le ndlela emfutshane ukufaka umsebenzi we-MAX:
- 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- MAX kwoluhlu ukufaka umsebenzi we-MAX kwiseli 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,447 ibonakala kwiseli ye-E2, kuba iyona nombolo engakhiyo enkulu kuloo mgca;
- Ukuba ucofa kwiseli E2 umsebenzi opheleleyo = MAX (A2: C2) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.