01 ka 01
Thola inombolo encane kunazo zonke, Isikhathi esheshayo, Isikhathi esifushane kunazo zonke, noma Usuku Lokuqala Kakhulu
I-MIN Function Overview
Umsebenzi we-MIN uthola njalo inombolo encane noma encane ohlwini lwamagugu, kodwa, kuye ngokuthi idatha kanye nendlela idatha ngayo, ingasetshenziswa futhi ukuthola:
- isikhathi esisheshayo;
- ibanga elifushane;
- ijubane eliphansi kakhulu;
- usuku lokuqala;
- izinga lokushisa eliphansi kakhulu;
- imali encane yemali.
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 weM MIN uqobo ungashintshi, ukusebenzisana kwazo ekusebenzelaneni nezinombolo ezifomeni ezihlukahlukene kubonakala, futhi kungenye isizathu esenza umsebenzi ube usizo kakhulu.
MIN Umsebenzi we-Syntax ne-Arguments
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, ukwahlukanisa kwama-comma, nokuphikisana .
I-syntax yomsebenzi we-MIN yilezi:
= MIN (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.
I-MIN Function Isibonelo
Ulwazi olungezansi luhlanganisa izinyathelo ezisetshenziselwa ukungena umsebenzi we-MIN esitokisini E2 esithombeni ngenhla. Njengoba kubonisiwe, ububanzi bezingqikithi zeseli zizofakwa njengengxabano yenombolo yomsebenzi.
Enye inzuzo yokusebenzisa izingqikithi zamangqamuzana noma uhla olukhethiwe ukuthi uma idatha ebangeni liguquka, imiphumela yomsebenzi izovuselela ngokuzenzakalelayo ngaphandle kokuthi ihlele ifomula ngokwayo.
Ukufaka umsebenzi we-MIN
Izinketho zokufaka ifomula zihlanganisa:
- ukuthayipha ifomula equkethe umsebenzi = MIN (A2: C2) ngokuqondile esitokisini E2 bese ucindezela ukhiye wokungena kwikhibhodi;
- ukufaka izingxabano usebenzisa ibhokisi lengxoxo ye-MIN ;
- Ukusebenzisa isinqamuleli somsebenzi we-MIN esisethempelini laseKhaya lebhebhoni .
Isinqamuleli se-MIN Function
Le nqamuleli yokusebenzisa umsebenzi we-Excel ka-MIN ingenye yemisebenzi eminingi evelele ye-Excel enezinqamuleli ezihlanganisiwe ndawonye ngaphansi kwesithonjana se- AutoSum kuthebhu yasekhaya yebhande.
Ukusebenzisa le nqamuleli ukungena umsebenzi we-MIN:
- 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-MIN ohlwini ukuze ufake umsebenzi we-MIN esitokisini E2;
- Qinisekisa amaseli A2 kuya ku-C2 kusikripthi sokusebenzela ukuze ufake lolu hlu njengengxabano yomsebenzi;
- Cindezela ukhiye wokungena kwikhibhodi ukuqedela umsebenzi;
- Impendulo -6,587,449 ivela esitokisini se-E2, ngoba yinombolo encane kunazo zonke kulezo zinsuku - izinombolo ezingalungile zithola kancane ukuthi zivela ku-zero;
- Uma uchofoza kumakhalekhukhwini E2 umsebenzi ophelele = MIN (A2: C2) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.