01 ka 01
Thola Inombolo Ekhulu kakhulu, Isikhathi Esincane, Indawo Ede kakhulu, noma Ukushisa Okuphakeme Kakhulu
Umsebenzi we-MAX uthola njalo inombolo enkulu kunazo zonke ohlwini lwamaxabiso, kodwa, kuye ngokuthi idatha kanye nendlela idatha ngayo, ingasetshenziswa futhi ukuthola:
- isikhathi esincane kakhulu;
- ibanga elide kakhulu;
- ijubane elisheshayo;
- usuku lwamuva;
- izinga lokushisa eliphakeme kakhulu;
- imali enkulu kakhulu.
Futhi nakuba kuvame ukulula ukuthola inani elikhulu kunazo zonke kwisampuli encane yezinombolo, umsebenzi uba nzima nakakhulu ngemali enkulu yedatha noma uma leyo datha kwenzeka:
- izinombolo ezimbi;
- izikhathi ezilinganiselwe ngekhulu leyesibili;
- Izinga lokushintshaniswa kwezimali libalwe ezinkulungwaneni eziyizinkulungwane eziyishumi;
- izinombolo ezifakwe njengezingxenyana;
Izibonelo zezinombolo ezinjalo ziboniswa esithombeni esingenhla, kanti ngenkathi umsebenzi we-MAX ngokwawo ungashintshi, ukusebenzisana kwazo ngokubhekana nezinombolo ezifomini ezihlukahlukene kubonakala, futhi kungenye isizathu esenza umsebenzi usebenziseke kakhulu.
Umsebenzi we-MAX weSintax nama-Arguments
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, ukwahlukanisa kwama-comma, nokuphikisana .
I-syntax yomsebenzi we-MAX yile:
= MAX (Inombolo1, Inombolo2, ... Inamba255)
Inombolo1 - (edingekayo)
Inombolo2: Inombolo255 - (ngokuzikhethela)
Izingxabano ziqukethe izinombolo ezizosetshenziselwa inani elikhulu kunazo zonke - kuze kufike ku-255.
Iziphakamiso zingaba:
- izinombolo;
- amabanga aqoshiwe ;
- izigcawu;
- izingqikithi zeseli endaweni yedatha kushidi lokusebenzela;
- Ama-boolean amanani afakwe ngqo ohlwini lwezingxabano.
Amanothi :
Uma izingxabano zingenayo izinombolo, umsebenzi uzobuyisa inani le-zero.
Uma i-array, uhla oluthiwa, noma ireferensi yeseli elisetshenziselwa impikiswano iqukethe:
- amaseli angenalutho;
- Amanani we-Boolean;
- idatha yombhalo
lawo maseli azinakwa yilo msebenzi njengoba kuboniswe kusibonelo emgqeni 7 esithombeni ngenhla.
Emgqeni wesi-7, inombolo engu-10 kuseli C7 ifomathiwe njengombhalo (phawula unxantathu ohlaza okwesibhakabhaka ekhoneni elingaphezulu kwesobunxele beseli elibonisa ukuthi inombolo igcinwa njengombhalo).
Ngenxa yalokho, yona, kanye ne-Boolean value (TRUE) kuseli A7 nesitoreji esingenalutho B7, ayinaki umsebenzi.
Ngenxa yalokho, umsebenzi ku-cell E7 ubuyisela i-zero impendulo, ngoba u-A7 kuya ku-C7 awuqukethe izinombolo.
Isibonelo se-MAX
Ulwazi olungezansi luhlanganisa izinyathelo ezisetshenziselwa ukungena umsebenzi we-MAX kumakhalekhukhwini E2 kusibonelo sesithombe ngenhla. Njengoba kubonisiwe, ububanzi bezingqikithi zeseli zizofakwa njengengxabano yenombolo yomsebenzi.
Enye inzuzo yokusebenzisa izingqikithi zamaseli noma ububanzi obuqanjwe ngokumelene nokufaka ngqo idatha ukuthi uma idatha ebangeni iguqula, imiphumela yomsebenzi izovuselela ngokuzenzakalelayo ngaphandle kokuba ihlele ifomu ngokwayo.
Ukufaka umsebenzi we-MAX
Izinketho zokufaka ifomula zihlanganisa:
- ukuthayipha ifomula equkethe umsebenzi = Max (A2: C2) ngokuqondile esitokisini E2 bese ucindezela ukhiye we- Enter ekhibhodi;
- ukufaka izingxabano usebenzisa ibhokisi lengxoxo ye-MAX ;
- Ukusebenzisa isinqamuleli sezinsizakalo ze-MAX esisethempelini laseKhaya lebhebhoni .
Isinqamuleli somsebenzi we-MAX
Lesi sinqamuleli sokusebenzisa umsebenzi we-Excel sika-MAX ungomunye wemisebenzi eminingi evelele ye-Excel enezinqamuleli eziqoqiwe ndawonye ngaphansi kwesithonjana se- AutoSum kuthebhu yasekhaya yebhande.
Ukusebenzisa le nqamuleli ukungena umsebenzi we-MAX:
- Chofoza kumakhalekhukhwini E2 ukuze wenze iseli esebenzayo
- Chofoza kuthebhu yaseKhaya yebhebhoni uma kunesidingo;
- Ngesikhathi sokugcina ngakwesokudla kwebhebhoni, chofoza umcibisholo ophansi eceleni kwe- Σ AutoSum inkinobho ukuvula uhlu lwezinto eziphansi;
- Chofoza ku- MAX kuhlu ukuze ufake umsebenzi we-MAX kuseli-E2;
- Qinisekisa amaseli A2 kuya ku-C2 kusikripthi sokusebenzela ukuze ufake lolu hlu njengengxabano yomsebenzi;
- Cindezela ukhiye wokungena kwikhibhodi ukuqedela umsebenzi;
- Impendulo -6,587,447 ivela esitokisini se-E2, ngoba yiyona inombolo enkulu kunazo zonke kulolo hlu;
- Uma uchofoza kweseli E2 umsebenzi ophelele = MAX (A2: C2) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.