Hanyar Hanyoyin Mutu na Excel: Gano Ƙimar Ƙarƙashin

01 na 01

Nemi Lambar Ƙananan, Lokacin Gyara, Ƙananan Distance, ko Ranar Farko

Nemi Lambar Ƙananan, Lokacin Mafi Saurin, Ƙananan Distance, Ƙananan Zazzabi, ko Ƙarshe Ranar tare da Function na MIN na Excel. © Ted Faransanci

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:

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:

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:

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:

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:

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:

  1. Danna kan tantanin halitta E2 don sa shi tantanin halitta mai aiki
  2. Danna kan Shafin shafin na kintinkin idan ya cancanta;
  3. A saman gefen dama na rubutun, danna kan gefen ƙasa kusa da Σ AutoSum button don buɗe jerin abubuwan da aka sauke;
  4. Danna MIN a jerin don shigar da aikin MIN a cikin cell E2;
  5. Sanya siffofin A2 zuwa C2 a cikin takardun aiki don shigar da wannan kewayon yayin gardamar aikin;
  6. Latsa maɓallin shigarwa a kan keyboard don kammala aikin;
  7. 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;
  8. Idan ka danna kan salula E2 cikakken aikin = MIN (A2: C2) ya bayyana a cikin wannan tsari a sama da takardun aiki.