Gwiritsani ntchito Njira Yopangira MaX ya Excel kuti Mupeze Miyambo Yaikulu Kwambiri

01 ya 01

Pezani Nambala Yaikulu Kwambiri, Nthawi Yochepa Kwambiri, Kutali Kwambiri Kwambiri, kapena Kutentha Kwambiri

Ntchito MAX nthawi zonse imapeza chiwerengero chachikulu kapena chachikulu pa mndandanda wamakhalidwe abwino, koma, malingana ndi deta komanso momwe deta imapangidwira, ikhonza kugwiritsidwa ntchito kupeza:

• nthawi yochedwa;
• mtunda wautali kwambiri;
• liwiro lofulumira;
• tsiku lomaliza;
• kutentha kwakukulu;
• ndalama zambiri.

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 mu chithunzi pamwambapa, ndipo pamene ntchito ya MAX isasinthe, kusinthasintha kwake pochita ndi nambala mu mawonekedwe osiyanasiyana kumaonekera, ndipo ndi chifukwa chimodzi chomwe ntchitoyi ilili othandizira.

Ntchito Yachiwiri Yowonjezereka ndi Mikangano

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

Chidule cha ntchito ya MAX ndi:

= MAX (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, ntchito mu selo E7 imabwereza zero pofuna yankho, chifukwa ma A7 mpaka C7 alibe ma nambala iliyonse.

Chitsanzo cha Ntchito MAX

Zomwe zili pansipa zikukhudza njira zomwe zingagwiritsidwe ntchito MAX mu selo E2 mu chitsanzo cha chithunzi pamwambapa. Monga tawonetsera, mafotokozedwe angapo a selo adzaphatikizidwa monga nambala yokhudza ntchito.

Chinthu chimodzi chogwiritsa ntchito zizindikiro za selo kapena dzina lotchulidwa mosiyana ndi kulumikiza mwachindunji deta ndi chakuti ngati deta iliyonse lisintha, zotsatira za ntchitoyi zidzasinthidwa popanda kusintha ndondomeko yokha.

Kulowa pa ntchito MAX

Zosankha zogwiritsa ntchito njirayi zikuphatikizapo:

• kulemba fomu yomwe ili ndi ntchito = Max (A2: C2) mwachindunji mu selo E2 ndikukankhira pakiyi ya Kulowa pa kibokosi;
• kulowetsa ziganizo pogwiritsa ntchito bokosi lazokambirana la MAX ;
• Pogwiritsa ntchito njira yachidule ya MAX yomwe ili pazithunzi zapakhomo.

Chotsatira Chogwira Ntchito MAX

Njira yamakono yogwiritsira ntchito Excel ya MAX ntchito ndi imodzi mwa ntchito zambiri za Excel zomwe zimakhala ndifupikitsidwa pamodzi pansi pazithunzi za AutoSum pa tsamba la Home la Ribbon.

Kuti mugwiritse ntchito njirayi kuti mulowe ntchito ya MAX:

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 MAX mumndandanda kuti mulowe ntchito ya MAX 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,447 likuwoneka mu selo E2, chifukwa ndi nambala yaikulu yosayenerera mumzerewu;
8. Ngati inu mutsegula pa selo E2 ntchito yonse = MAX (A2: C2) ikuwoneka mu barra ya fomu pamwamba pa tsamba.