Aiki "Min" a Fore Excel

Ayyukan Syntax

SynTax na kowane aiki a Excel shine dokokin rikodin da dole ne a lura dashi don lissafin al'ada. Aikin "Min" yana da hujja guda ɗaya kawai, wanda za'a iya shimfida zuwa lambar Unlimited. Don yin rikodin shi, a cikin lambar "lambar" ko tare da rikodin kayan aiki na Arrays, ana nuna lambobin lambobi ko rukuni na sel a jere ko kuma ana zaba.

A wannan yanayin, muhawara ta iya zama lambar da ba tabbas ba. Lokacin rubuta zuwa "Muhawara muhawara na aiki", an ƙara sabon layin ta atomatik bayan cika na farko, da kuma rikodin rubu'i, alamar da aka ware ta hanyar daidaitaccen alama ";".

Lura cewa zaku iya shiga cikin gardama cikakken kowane tsararrun bayanai, amma ana yin watsi da rubutu da mahimman mahimman bayanai, kuma ana la'akari da tsarin ƙididdiga kawai. Yi la'akari da wannan a gaba kuma canza tsarin sel, idan ya cancanta.

Misali rikodin aiki min

Za mu bincika aikin "Min" ana yin rikodin aikin "la'akari da wannan don kowane mai amfani ya fahimci cewa ya kamata a yi takamaiman lissafin.

1. Rikodin aikin "min", kamar yadda aka saba, yana farawa da talla. Don yin wannan, rubuta a cikin zaɓaɓɓen tantanin halitta = min (). Matsar da siginan kwamfuta tsakanin bangarorin zagaye don fara rikodin muhawara.



2. Zaɓi maɓallin linzamin kwamfuta na hagu tare da kewayon bayanai wanda za'a samo mafi ƙarancin darajar. Zai bayyana a cikin tsari da kansa kamar A1: A22.



3. Latsa maɓallin Shigar kuma zaku ga mafi ƙarancin darajar daga kewayon da aka ƙayyade a cikin tantanin halitta.



4. Kara bayan da farko da bayanai ";", wanne ne mai raba gargajiya.



5. Zaɓi tsararrawa na biyu ko ƙara kowane lamba don kwatanta shi da shi.



6. Bayan latsa maɓallin shigar, zaku ga cewa yanzu lokacin da ƙididdige mafi ƙarancin ƙimar, duk mahawara ana la'akari da shi.

Zaka iya yanke shawarar yadda yanayi zai zama mafi kyau duka don amfani da irin wannan aikin idan ba shi da wahala don ƙayyade ƙarancin da hannu.

Yin amfani da aikin "min" a cikin wasu ayyuka

Excel ya ƙunshi ƙarin dabarun rikitarwa waɗanda ke nuna amfani da ayyuka da yawa. Misali, yi la'akari da gabatarwar "min" a cikin "idan" a matsayin magana mai ma'ana. Dukkanin ayyuka za a yi a cikin "muhawara ta aikin" taga, kuma zaku iya sanin kanku da syngux da kuma daidaita rubutun da kanku.

1. Ayyana "idan" aiki ko wani a cikin waɗanne ma'adanan za a yi amfani, sannan danna maɓallin "Ayyukan Aiki" don fara wannan taga kanta.



2. A ciki, a matsayin tushen ma'ana mai ma'ana, saita aikin "min" tare da bayanan da aka sanar da su kamar yadda aka riga aka nuna a sama.



3. Misara magana mai ma'ana, misali ga tabbatar da gaskiya ko karya.



4. Ya rage don tantance ƙa'idodin biyu na ƙarshe waɗanda zasu fito da gaskiya ko karya.



5. Komawa tebur kuma duba sakamakon. A cikin sikelin na gaba zaka ga cikakken hoto na rikodin aikin da aka watsa.

Dingara ayyukan lissafi

A misali na karshe, mun bincika ƙungiyar da yawa "min" a cikin sakamako guda ɗaya ta amfani da ayyukan lissafi. Ana buƙatar wannan, alal misali, lokacin da kuke buƙatar ɗaukar lambobi biyu daga samfurori daban-daban kuma ku taƙaita su. A wannan yanayin, tsarin naúrar ya kasance daidai.

1. Sanar da aikin farko "Min" kuma yin rikodin shi a cikin hanyar kamar yadda aka nuna a cikin sassan da suka gabata na labarin.



2. Sanya alamar aikin lissafi kuma ka ayyana aikin na biyu "min".



3. Latsa Shigar don tabbatar da aikin kuma tabbatar da cewa ƙari, Add'i, ragewa ko kamfanoni ya wuce cikin nasara.