01 ye 01
Tsvaga Nhamba Yakakura Kupfuura, Yakaderera Nguva, Yakareba Kure Kure, kana Kupisa Kwakaipisisa
Iko MAX basa inowanzowana nhamba yakakura kana yepamusoro pane urongwa hwehutsika, asi, zvichienderana nedzimwe uye nzira iyo data yakarongwa, inogona kushandiswawo kuwana:
- nguva inononoka;
- kure kure kure;
- kumhanya kunokurumidza;
- the latest date;
- yakanyanya kutonhora;
- mari yakawanda kwazvo.
Uye kunyange zvazvo zvichangova nyore kutsanangura kukosha kukuru mune imwe samuenzaniso ye integers, basa rinova rakaoma zvikuru kune zvakawanda zve data kana kana dhiyo iyoyo ichiitika:
- nhamba dzisina kunaka;
- nguva dzinoyerwa muzana zana rechipiri;
- mari inoshandiswa mari yakaenzana kusvika zviuru gumi zvezana;
- nhamba dzakarongwa sezvikamu;
Mienzaniso yenhamba dzakadaro inoratidzwa mumufananidzo uri pamusoro, uye kana MAX basa pachayo isingashanduki, kushandiswa kwayo zvakasiyana mukubata nemhando mumhando dzakasiyana-siyana kunoratidzika, uye ndicho chikonzero chimwe chinoita kuti basa rikubatsire.
MAX Function Syntax uye Arguments
Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemavara, uye nharo .
Mutsara weMaX function ndewokuti:
= MAX (Nhamba1, Nhamba2, ... Nhamba255)
Nhamba1 - (inoda)
Nhamba2: Nhamba255 - (zvichida)
Nharo dzine nhamba dzinotsvaga kukosha kwepamusoro-kusvika kusvika pa 255.
Nharo dzinogona kuva:
- nhamba;
- akatumidza mazita ;
- arrays;
- sero references kune nzvimbo yedhesi mune pepa rekushanda;
- Bhoolean maitiro anonyorwa zvakananga muurongwa hwemashoko.
Notes :
Kana zvikonzero zvisina nhamba, basa racho richadzoka kukosha kwe zero.
Kana yakagadzirwa, yakatumidzwa zita, kana sero rinoshandiswa munharo rine:
- masero asina chinhu;
- Boolean zvinokosha;
- text data
iyo masero haafaniri kutarisirwa nebasa sezvararatidzwa mumuenzaniso mumutsara we7 mumufananidzo uri pamusoro.
Mutsara we7, nhamba yegumi muchitokisi C7 inenge yakasanganiswa semashoko (nyora denderedzwa yakasvibirira kumusoro kwekona yakasara rekamuri iri kuratidza kuti nhamba inochengetwa semashoko).
Semugumisiro, iyo, pamwe neBoolean kukosha (TRUE) muchitokisi A7 uye isina chengetani B7, inoratidzirwa nebasa racho.
Somugumisiro, basa riri muchitokisi E7 rinodzoka zero kuti ripindure, sezvo rutivi rweA7 kusvika kuC7 haruna nhamba ipi zvayo.
MAX Function Example
Izwi iri pasi apa rinoshandisa matanho anoshandiswa kupinda maMaX function mumusero E2 mumuenzaniso wemufananidzo pamusoro apa. Sezvinoratidzwa, ruzhinji rwemaferensi echitokisi huchabatanidzwa sehupikisi yenhamba yebasa.
Rimwe ruzivo rwekushandisa sero zvinyorwa kana zita rakarongedzerwa rinopesana nekupinda zvakananga data ndeyokuti kana data iri mumararamiro achichinja, mhinduro dzebasa racho dzichagadzirisa pasina kudikanwa kwekugadzirisa maitiro acho pachayo.
Kupinda MAX Basa
Sarudzo dzekupinda mufomu dzinosanganisira:
- kunyora rondedzero ine basa = Max (A2: C2) zvakananga muchitokisi E2 uye kuvhara muIno yokupinda pane keyboard;
- kupinda mumagwaro uchishandisa MAX function's box box;
- Kushandisa nzira shoma yeHS MAX iri paImba yebhu yebhoni .
MAX Kushanda Shortcut
Iyi nzira shoma yekushandisa Excel MAX basa ndechimwe chezvinhu zvakasiyana-siyana zvakakurumbira zveEexcel zvine zvishoma zvishoma zvakabatana pamwechete pasi peAustSum icon paImba yebhu yebhoni.
Kushandisa iyo nzira shoma yekupinda MAX basa:
- Dzvanya pachitokisi E2 kuti uite sero rinoshanda
- Dzvanya paImba yebhu yebhoni kana zvichidiwa;
- Pamugumo wekurudyi webhoni, tsvaira pfuti iri pasi pedo ne Σ AutoSum bhatani kuti uzarure rondedzero rwemabasa;
- Dzvanya pa MAX mumutsetse kuti upinde maMaX function mumusero E2;
- Simbisai masero A2 kusvika kuC2 mune pepa rekushandisa kuti uise hutabhenakeri iyi senyaya yebasa;
- Dhinda pikicha inopinda mubhokisi kuti upedze basa;
- Mhinduro -6,587 447 inowanikwa muchitokisi E2, sezvo iri nhamba isina kunaka zvikuru mumutsara iwoyo;
- Kana iwe ukatarira pane cell E2 basa rakakwana = MAX (A2: C2) inowanikwa mubhairi yepamusoro pane pepa pepaji.