Ntchito ya Excel MODE.MULT

Masamu, pali njira zingapo zowunikira chizoloŵezi chachikulu kapena, monga momwe zimatchulira kawirikawiri, chiwerengero cha zikhalidwe. Kawirikawiri kukhala pakati kapena pakati pa chiwerengero cha ziwerengero mu kufalitsa kwa ziwerengero.

Pankhani ya machitidwe, pakati imatanthawuza kufunika kowoneka kawirikawiri pamndandanda wa manambala. Mwachitsanzo, njira 2, 3, 3, 5, 7, ndi 10 ndiyo nambala 3.

Kuti zikhale zosavuta kuyeza chizoloŵezi chapakati, Excel ili ndi ntchito zingapo zomwe zikhoza kuwerengera zomwe zimagwiritsidwa ntchito kwambiri. Izi zikuphatikizapo:

• Ntchito ya MODE.SNGL - imapeza njira kapena nthawi zambiri zomwe zimawoneka pazinthu zamndandanda .
• Ntchito ya MODE.MULT - yogwiritsidwa ntchito kuti adziwe ngati deta ili ndi mitundu yambiri - kuchuluka kwa mtengo umodzi kumawoneka mndandanda wa manambala
• Ntchito ya MEDIAN - imapeza mtengo wapakati kapena pakati pakati pa manambala
• Ntchito YOPHUNZITSIRA - imapeza chiwerengero cha masamu kumatanthauza mndandanda wa nambala

01 ya 05

Momwe MODE.MULT Function Works ikuchitira

Mu Excel 2010, ntchito ya MODE.MULT inayambika kuti iwonjezeke pa ntchito ya MODE yomwe inapezeka m'mawambidwe a Excel.

M'masinthidwe akale aja, ntchito ya MODE idagwiritsidwa ntchito kupeza chinthu chimodzi chokha chomwe chimachitika - kapena mndandanda - mndandanda wa manambala.

MODE.MULT, komano, adzakuuzani ngati pali machitidwe angapo - kapena ma modes - omwe amapezeka kawirikawiri pamtundu wambiri .

Zindikirani: ntchitoyo imabwereza ma modesero ngati ziwerengero ziwiri kapena zingapo zikupezeka ndifupipafupi mofanana pakati pa deta yosankhidwa. Ntchitoyi siyikulongosola deta.

02 ya 05

Mzere kapena CSE Mafomu

Pofuna kubwezeretsa zotsatira zambiri, MODE.MULT iyenera kulowetsedwa ngati njira yowonjezera - yomwe imapezeka m'maselo ambiri nthawi imodzi, popeza ma excel omwe nthawi zonse amatha kubwezera zotsatira imodzi pa selo.

Zowonjezera zolembedwera zimalowetsedwa mwa kukakamiza makiyi a Ctrl , Shift , ndi Enter mu khibodi yomweyo pokhapokha chiganizocho chapangidwa.

Chifukwa cha mafungulo omwe akulimbikitsidwa kuti alowe muyeso, nthawi zina amatchulidwa kuti CSE .

03 a 05

Syntax ndi Arguments MODE.MULT Function

Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .

Chidule cha ntchito ya MODE.MULT ndi:

= MODE.MULT (Number1, Number2, ... Number255)

Nambala - (yofunika) miyezo (mpaka 255) yomwe mukufuna kuwerengera. Mtsutso uwu ukhoza kukhala ndi manambala enieni - olekanitsidwa ndi makasitomala - kapena akhoza kutanthauzira selo kwa malo a deta muzenera.

Chitsanzo Pogwiritsa Ntchito Excel MODE.MULT Ntchito:

Chitsanzo chowonetsedwa pa chithunzi pamwambapa chili ndi njira ziwiri - nambala 2 ndi 3 - zomwe zimachitika nthawi zambiri mu deta yosankhidwa.

Ngakhale kuti pali zinthu ziwiri zokha zomwe zimapezeka ndifupipafupi, ntchitoyi yalowa mu maselo atatu.

Chifukwa maselo ambiri amasankhidwa kusiyana ndi ma modes, selo lachitatu - D4 - limabweretsanso vuto la # N / A.

04 ya 05

Kulowa ntchito ya MODE.MULT

Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:

1. Kujambula ntchito yonse: = MODE.MULT (A2: C4) mu selo lamasewera
2. Kusankha ntchito ndi zifukwa pogwiritsa ntchito bokosi la bokosi la ntchito

Kwa njira zonsezi, ndondomeko yotsiriza ndiyo kulowa ntchito monga ntchito yosiyanasiyana pogwiritsa ntchito makiyi a Ctrl , Alt , ndi Shift monga mwatsatanetsatane.

Bokosi la Ma Dialog MODE.MULT

Mndandanda pansipa tsatanetsatane momwe mungasankhire MODE.MULT ntchito ndi zifukwa pogwiritsa ntchito bokosi.

1. Onetsetsani maselo D2 ku D4 pa tsamba kuti muwasankhe - maselo awa ndi malo omwe zotsatira za ntchitoyo zidzawonetsedwa
2. Dinani pa Fomu ya Fomu
3. Sankhani Ntchito Zambiri> Chiwerengero chochokera ku riboni kuti mutsegule ntchitoyi
4. Dinani pa MODE.MULT mndandanda kuti mubweretse bokosi lazokambirana
5. Onetsetsani maselo A2 ku C4 mu tsamba lokuthandizani kuti mulowe muzenera

05 ya 05

Kupanga Mpangidwe Wowonjezera

1. Dinani ndi kugwira Ctrl ndi Shift mafungulo pa makiyi
2. Lembani fungulo lolowamo ku Enter mu makina kuti mupange ndondomeko yambiri ndi kutseka bokosi

Zotsatira Zotsatira

Zotsatira zotsatirazi ziyenera kukhalapo:

• nambala 2 mu selo D2;
• nambala 3 mu selo D3;
• ndi # N / A mu selo D4.

1. Zotsatirazi zimachitika chifukwa nambala ziwiri zokha - 2 ndi 3 - zimawonekera kawirikawiri ndipo zimakhala zofanana mofanana mu chitsanzo cha deta
2. Ngakhale nambala 1 imachitika kangapo - m'maselo A2 ndi A3 - siyikufanana ndi mafupipafupi a chiwerengero cha 2 ndi 3 kotero kuti sichiphatikizidwa ngati imodzi mwa njira zopezera deta
3. Mukasindikiza pa selo D2, D3, kapena D4 ndondomeko yonse

   {= MODE.MULT (A2: C4)}

   Zitha kuwonedwa muzenera zamatabwa pamwamba pa tsamba

Mfundo:

• Ngati palibe njira - kapena, mwazinthu zina, deta ilibe deta yosawerengeka - ntchito ya MODE.MULT idzabweretsa vuto la # N / A mu selo iliyonse yosankhidwa kuti iwonetsere ntchitoyo
• Maselo osiyanasiyana akusankhidwa kuti awone zotsatira za MODE.MULT ntchito iyenera kuyenderera. Ntchitoyi siidzapereka zotsatira ku maselo osakanikirana.
• Ngati mtengo wofunika wosakanikirana ukufunika, ntchito ya MODE.MULT ikhoza kukhala chisa mkati mwa ntchito TRANSPOSE
• Maonekedwe a equation adzakhala: {= TRANSPOSE (MODE.MULT (A2: C4)}