Excel MIN Ntchito Yophatikiza Njira: Pezani Mfundo Zing'onozing'ono

01 ya 01

Pezani Nambala Ying'ono Kwambiri, Nthawi Yowirikiza, Yoyandikira Kwambiri, kapena Tsiku Lakale Kwambiri

MIN Ntchito Zowonetsera

Ntchito ya MIN nthawi zonse imapeza nambala yaing'ono kapena yocheperapo mndandanda wamakhalidwe abwino, koma, malingana ndi deta komanso momwe deta imapangidwira, ikhonza kugwiritsidwa ntchito kupeza:

• nthawi yofulumira;
• mfupi kwambiri;
• liwiro lapansi;
• tsiku loyamba;
• kutentha kwakukulu;
• ndalama zochepa.

Ndipo ngakhale kuti nthawi zambiri zimakhala zosavuta kupeza phindu lalikulu pazitsanzo zazing'ono, ntchitoyo imakhala yovuta kwambiri pa deta kapena ngati deta ili:

• nambala zolakwika;
• nthawi zowerengedwa mu zana lachiwiri;
• malire osinthitsa ndalama amawerengera zikwi khumi za zana;
• nambala zowerengedwa ngati magawo;

Zitsanzo za nambala zoterezi zikuwonetsedwa pa chithunzi pamwambapa, ndipo pomwe ntchito ya MVI isasinthe, kugwirizana kwake pakuchita ndi nambala mu maonekedwe osiyanasiyana ndiwonekeratu, ndipo ndi chifukwa chimodzi chomwe ntchitoyi ilili othandizira.

MIN Function Syntax ndi Arguments

Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa .

Chidule cha ntchito ya MIN ndi:

= MIN (Namba1, Number2, ... Number255)

Nambala1 - (yofunika)

Number2: Number255 - (zosankha)

Zokambirana zili ndi manambala kuti afufuze mtengo waukulu - mpaka kufika pa 255.

Zikhoza kukhala:

• nambala;
• mayina otchulidwa ;
• zolemba;
• mafotokozedwe a selo kumalo a deta muzenera;
• Zolemba za Boolean zimasindikizidwa mwachindunji mndandanda wa zokangana.

Mfundo :

Ngati zifukwazo sizikhala ndi manambala, ntchitoyi idzabwezera mtengo wa zero.

Ngati mndandanda, wotchulidwa dzina, kapena selo yogwiritsidwa ntchito mu mkangano uli ndi:

• maselo opanda kanthu;
• Zofunika za Boolean;
• deta yamtundu

maselo awo amanyalanyazidwa ndi ntchito monga momwe zasonyezera mu chitsanzo mzere 7 mu chithunzi pamwambapa.

Mzere 7, nambala 10 mu selo C7 imapangidwira ngati malemba (onetsetsani katatu katsamba pamwamba pa ngodya ya pamwamba ya selo yomwe ikusonyeza kuti chiwerengero chasungidwa ngati chilembo).

Chotsatira chake, icho, pamodzi ndi mtengo wa Boolean (TRUE) mu selo A7 ndi selo yopanda kanthu B7, sagwiritsidwe ndi ntchitoyo.

Zotsatira zake, ntchitoyi mu selo E7 imabwerera zero pofuna yankho, chifukwa ma A7 mpaka C7 angakhale opanda nambala.

MIN Function Chitsanzo

Zomwe zili pansipa zikuphatikiza njira zomwe zingagwiritsire ntchito MIN ntchito mu selo E2 mu chithunzi pamwambapa. Monga tawonetsera, mafotokozedwe angapo a selo adzaphatikizidwa monga nambala yokhudza ntchito.

Chinthu chimodzi chogwiritsa ntchito zizindikiro za selo kapena dzina lotchulidwa ndizoti ngati deta iliyonse kusintha, zotsatira za ntchitoyi zidzasinthidwa popanda kusintha ndondomeko yokha.

Kulowa Ntchito ya MIN

Zosankha zogwiritsa ntchito njirayi zikuphatikizapo:

• kulemba fomu yomwe ili ndi ntchito = MIN (A2: C2) mwachindunji mu selo E2 ndikukankhira pakiyi pa Enter mukhiyo;
• kulowetsa ziganizo pogwiritsa ntchito bokosi la dialogue la MIN function ;
• Pogwiritsa ntchito njira yachidule ya MIN yomwe ili pa tsamba la kunyumba la nthiti .

Chotsatira Chogwira Ntchito ya MIN

Njira yamakono yogwiritsira ntchito ntchito ya Excel ndi imodzi mwa ntchito zamtundu wotchuka wa Excel zomwe zili ndi zidule zomwe zimagwirizanitsidwa pansi pazithunzi za AutoSum pazithunzi za Pakiti .

Kuti mugwiritse ntchito njirayi kuti mulowe ntchito MIN:

1. Dinani pa selo E2 kuti mupange selo yogwira ntchito
2. Dinani pa tsamba la Home la Ribbon ngati kuli kofunikira;
3. Pamphepete wakumapeto kwa riboni, dinani pamsana wotsika pambali pa Σ AutoSum batani kuti mutseke mndandanda wa ntchito;
4. Dinani pa MIN mu mndandanda kuti mulowetse MIN ntchito mu selo E2;
5. Onetsetsani maselo A2 kuti C2 mu tsamba lolemba kuti mulowe muyeso ili monga kukangana kwa ntchito;
6. Lembani fungulo lolowamo lolowamo mu khibhodi kuti mukwaniritse ntchitoyo;
7. Yankho -6,587,449 likupezeka mu selo E2, chifukwa ndi nambala yaing'ono kwambiri mu mzerewu - nambala zolakwika zimachepetsanso zomwe zikuchokera ku zero;
8. Ngati inu mutsegula pa selo E2 ntchito yonse = MIN (A2: C2) ikuwoneka mu barra ya fomu pamwamba pa tsamba.