Sebenzisa i-Excel ye-Excel ye-MAX Umsebenzi yeNqakrazo yokuFumana iMilinganiselo ephezulu kakhulu

01 ngo 01

Fumana inani elikhulu kakhulu, ixesha elide kakhulu, umgama omde kakhulu, okanye ukushisa okuphezulu

Fumana iNani elikhulu kunazo zonke, ixesha elide kakhulu, umgama omde kakhulu, ukushisa okuphezulu, okanye usuku lokugqibela nge-Excel ye-MAX Umsebenzi. © Ted French

Umsebenzi we-MAX uhlala ufumana inamba enkulu okanye enkulu kwinani lexabiso, kodwa, ngokuxhomekeke kwidatha nendlela eyafomatha ngayo, ingasetyenziselwa ukufumana:

Kwaye ngelixa kunzima ukukhetha ixabiso elikhulu kwinani elincinci le-integers, umsebenzi unzima kunzima kwixabiso elikhulu leenkcukacha okanye ukuba loo datha yenzeka:

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:

Amanqaku :

Ukuba iingxoxo aziqukethe amanani, umsebenzi uya kubuya ixabiso lentlawulo.

Ukuba uluhlu, uluhlu olukhankanyiweyo, okanye iselferensi yeseli esetyenziswe kwingxabano iqulethe:

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:

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:

  1. Cofa kwifowuni E2 ukwenzela ukuba ibe yiseli esebenzayo
  2. Cofa kwiThebhu yasekhaya yerbhoni xa kuyimfuneko;
  3. Kwiphepha elide lasekunene lebhebhoni, nqakraza kwinqolo engezantsi kwicala le Σ AutoSum ukuvula uluhlu lwemisebenzi ephantsi;
  4. Cofa kwi- MAX kwoluhlu ukufaka umsebenzi we-MAX kwiseli E2;
  5. Gqamisa iiseli ezi-A2 ukuya kwi-C2 kwiphepha lokusebenzela ukuze ufake olu luhlu njengengxabano yomsebenzi;
  6. Cinezela ukhiye wokungena kwikhibhodi ukugqiba umsebenzi;
  7. Impendulo -6,587,447 ibonakala kwiseli ye-E2, kuba iyona nombolo engakhiyo enkulu kuloo mgca;
  8. Ukuba ucofa kwiseli E2 umsebenzi opheleleyo = MAX (A2: C2) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.