01 na 01
Nemi Lambar Ƙananan, Lokacin Gyara, Ƙananan Distance, ko Ranar Farko
MIN Function Overview
Ayyukan MIN na samo mafi ƙanƙanci ko mafi yawan lambar a lissafin dabi'u, amma, dangane da bayanan da yadda aka tsara bayanin, za'a iya amfani dashi don gano:
- lokacin mafi sauri;
- mafi nisa;
- mafi sauri mafi sauri;
- kwanan wata;
- mafi zafi mafi ƙasƙanci;
- yawan kuɗin kuɗi.
Kuma yayin da sau da yawa sauƙin sauƙi mafi yawan adadi a cikin ƙananan samfurin mahaɗi, aikin zai zama da wuya ga yawancin bayanai ko kuma idan wannan lamarin ya faru ne:
- lambobi masu ma'ana;
- lokutan da aka auna a cikin ɗari na na biyu;
- kudaden musayar kudin da aka ƙididdige zuwa dubun dubban cent;
- Lambobin da aka tsara a matsayin raunuka;
Misalai na waɗannan lambobi suna nunawa a cikin hoton da ke sama, kuma yayin da aikin MIN ba zai canza ba, ƙwarewarsa wajen yin amfani da lambobi a cikin nau'i-nau'i daban-daban ya bayyana, kuma shine dalili daya da ya sa aikin ya kasance da amfani.
MIN Aiki Daidaitawa da Magana
Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara .
Haɗin aikin MIN ɗin shine:
= MIN (Number1, Number2, ... Number255)
Number1 - (buƙatar)
Number2: Number255 - (na zaɓi)
Ƙididdigar sun ƙunshi lambobin da za'a bincika don mafi girma - har zuwa iyakar 255.
Tambaya na iya zama:
- lambobi;
- jerin jeri ;
- kayan aiki;
- tantanin halitta sunyi bayanin wuri na bayanai a cikin takardun aiki;
- Boolean dabi'u sunyi rubutu kai tsaye cikin jerin jayayya.
Bayanan kula :
Idan jayayya ba su ƙunshi lambobi ba, aikin zai dawo da darajar sifilin.
Idan wani tsararraki, mai lakabi mai suna, ko ƙirar salula wanda aka yi amfani da shi a cikin gardama ya ƙunshi:
- kullun kullun;
- Boolean dabi'u;
- bayanan rubutu
ana watsi da waɗannan kwayoyin ta wurin aikin kamar yadda aka nuna a misali a jere 7 a cikin hoto a sama.
A jere na 7, an tsara lamba 10 a cikin cell C7 a matsayin rubutu (lura da tauraron kore a cikin hagu na hagu na tantanin halitta yana nuna cewa an adana lambar a matsayin rubutu).
A sakamakon haka, tare da Boolean darajar (TRUE) a cikin tantanin halitta A7 da ƙananan cell B7, ana watsi da aikin.
A sakamakon haka, aikin a cikin cell E7 ya koma zero don amsar, tun da kewayon A7 zuwa C7 ba ya ƙunshi lambobi.
MIN Aikace-aikace Misali
Bayanin da ke ƙasa ya rufe matakan da ake amfani dashi don shigar da aikin MIN a cikin cell E2 a cikin hoton da ke sama. Kamar yadda aka nuna, za a hada raƙumomin tantancewar salula a matsayin ƙididdigin lamba don aikin.
Ɗaya daga cikin amfani da yin amfani da labaran ƙwayoyin salula ko lakabi mai suna shi ne cewa idan bayanai a cikin kewayon sun canza, sakamakon aikin zai sabunta ta atomatik ba tare da shirya tsarin da kanta ba.
Shigar da aikin MIN
Zaɓuɓɓuka don shigar da wannan tsari sun haɗa da:
- rubuta tsarin da ya ƙunshi aikin = MIN (A2: C2) kai tsaye zuwa cikin cell E2 kuma latsa maɓallin shigarwa akan keyboard;
- shigar da muhawara ta amfani da maganganun ta MIN ɗin ;
- Amfani da gajerar aikin na MIN wanda yake a kan shafin shafin shafin rubutun .
MIN Aiki Hanyar gajere
Wannan gajeren hanya don yin amfani da aikin na Excel na MIN shine ɗaya daga ayyukan da ke da yawa na Excel waɗanda ke da hanyoyi masu rarraba a haɗe a ƙarƙashin ta atomatik AutoSum a kan shafin shafin shafin rubutun.
Don amfani da wannan gajeren hanyar don shigar da aikin MIN:
- Danna kan tantanin halitta E2 don sa shi tantanin halitta mai aiki
- Danna kan Shafin shafin na kintinkin idan ya cancanta;
- A saman gefen dama na rubutun, danna kan gefen ƙasa kusa da Σ AutoSum button don buɗe jerin abubuwan da aka sauke;
- Danna MIN a jerin don shigar da aikin MIN a cikin cell E2;
- Sanya siffofin A2 zuwa C2 a cikin takardun aiki don shigar da wannan kewayon yayin gardamar aikin;
- Latsa maɓallin shigarwa a kan keyboard don kammala aikin;
- Amsar -6,587,449 ya bayyana a cikin cell E2, tun da yake shi ne mafi ƙanƙanci yawancin mummunar a cikin wannan jere - lambobin maɓallin lamarin da ya rage ƙarami sun kasance daga sifili;
- Idan ka danna kan salula E2 cikakken aikin = MIN (A2: C2) ya bayyana a cikin wannan tsari a sama da takardun aiki.