01 ye 01
Tsvaga Nhamba Dukuduku, Nguva Inokurumidza Kupfupika, Yakanyanya Kupfupika, Kana Zuva Rokutanga
MIN Function Overview
Basa reM MIN rinowanzowana nhamba duku kana inonyoresa pane mazita ehutsika, asi, zvichienderana nedheta uye nzira iyo data yakarongwa, inogona kushandiswawo kuwana:
- nguva inokurumidza;
- iri pfupi;
- iyo yakaderera nokukurumidza;
- zuva rekutanga;
- yakadzika kupfuura ushamwari;
- mari shoma yemari.
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 nepo MIN basa pachayo risina kuchinja, kushandiswa kwayo zvakasiyana mukubata nemhando mumhando dzakasiyana-siyana kunoratidzika, uye ndicho chimwe chikonzero nei basa racho richibatsira.
MIN Kushanda Syntax uye Arguments
Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemavara, uye nharo .
Mutsara weM MIN basa nderokuti:
= MIN (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 C7 risina nhamba.
MIN Kushanda Muenzaniso
Mashoko aya ari pasi apa anotaura matanho anoshandiswa kupinda muM MIN basa muchikamu cheE2 mumufananidzo uri pamusoro. Sezvinoratidzwa, ruzhinji rwemaferensi echitokisi huchabatanidzwa sehupikisi yenhamba yebasa.
Rimwe ruzivo rwekushandisa sero zvinyorwa kana kuti zita rakarongwa nderokuti kana data iri muhutano ichichinja, mhinduro dzebasa racho dzichagadzirisa pasina kudikanwa kwekushandura iyo fomu pachayo.
Kupinda MIN Function
Sarudzo dzekupinda mufomu dzinosanganisira:
- kunyora rondedzero ine basa = MIN (A2: C2) zvakananga muchitokisi E2 uye kuvhara muIno yokupinda pane keyboard;
- kupinda mumagwaro uchishandisa MIN function's dialog box;
- Kushandisa nzira shoma ye MIN inowanikwa paImba yebhu yebhoni .
MIN Function Shortcut
Iyi nzira shoma yekushandisa Excel's MIN basa ndechimwe chezvinhu zvakasiyana-siyana zvinonzi Excel zvinoshandisa zvishoma zvishoma pasi peAustSum icon paImba yebhu yebhoni.
Kushandisa iyo nzira shoma yekupinda MIN function:
- 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 paM MIN muchirongwa kuti upinde MIN basa muchitokisi E2;
- Simbisai masero A2 kusvika kuC2 mune pepa rekushandisa kuti uise hutabhenakeri iyi senyaya yebasa;
- Dhinda pikicha inopinda mubhokisi kuti upedze basa;
- Mhinduro -6,587449 inowanikwa muchitokisi E2, sezvo iri nhamba duku kudarika mumutsara - nhamba dzisina kunaka dzinowedzera zvishoma kubva kune zero;
- Kana iwe ukanyora pachitokisi E2 zvakakwana basa = MIN (A2: C2) inowanikwa mubhairi yepamusoro pane pepa pepaji.