01 na 01
Gano Lambar Mafi Girma, Lokacin Slowest, Tsawon Nisa, ko Mafi Girma Zazzabi
Ayyukan MAX kullum suna samun mafi girma ko iyakar lambar a lissafin dabi'un, amma, dangane da bayanan da yadda aka tsara bayanin, ana iya amfani dashi don gano:
- lokacin jinkirin;
- mafi nisa;
- gudun sauri;
- sabuwar kwanan wata;
- mafi yawan zazzabi;
- mafi yawan 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 nuna a cikin hoton da ke sama, kuma yayin da aikin MAX ba ya canzawa, ƙwarewarsa wajen magance lambobi a cikin nau'i-nau'i daban-daban ya bayyana, kuma shine dalili daya da ya sa aikin ya kasance da amfani.
MAX Ayyukan aiki 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 MAX shine:
= MAX (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.
MAX Ayyukan Kasuwanci
Bayanin da ke ƙasa ya rufe matakan da ake amfani dashi don shigar da aikin MAX a cikin cell E2 a cikin misalin hoto a 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 bayanan salula ko lakabi mai suna kamar yadda ya dace da shigar da bayanai cikin sauri shine cewa idan bayanan da ke cikin kewayawa ya canza, sakamakon aikin zai sabunta ta atomatik ba tare da gyara tsarin da kanta ba.
Shigar da aikin MAX
Zaɓuɓɓuka don shigar da wannan tsari sun haɗa da:
- rubuta tsarin da ya ƙunshi aikin = Max (A2: C2) kai tsaye zuwa cikin cell E2 kuma latsa maɓallin Shigar da ke keyboard;
- shigar da muhawara ta amfani da akwatin maganganun MAX na aikin ;
- Yin amfani da maɓallin MAX aiki a kan shafin shafin shafin rubutun .
MAX Ayyukan Jagorar hanya
Wannan gajeren hanya don yin amfani da aikin MAX na Excel yana ɗaya daga cikin ayyuka na Excel masu yawa waɗanda ke da gajerun hanyoyi da aka haɗa a ƙarƙashin icon na AutoSum a kan shafin shafin shafin rubutun.
Don amfani da wannan gajerar don shigar da aikin MAX:
- 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 MAX a jerin don shigar da aikin MAX 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,447 ya bayyana a cikin cell E2, tun da shi ne mafi girma lamba a cikin wannan jere;
- Idan ka danna kan tantanin halitta E2 cikakken aikin = MAX (A2: C2) ya bayyana a cikin maɓallin tsari a sama da takardun aiki.