Mndandanda wa zosinthika mu Excel

Mutha kupanga masanjidwe mu Microsoft Excel omwe samasungidwa m'ma cell. Nthawi zambiri amatchedwa mndandanda wa zokhazikika. Mu phunziro ili, muphunzira kuti masanjidwe osasintha amakhala bwanji komanso momwe mungagwirire nawo ntchito mu Excel.

Mwachidule za magulu osiyanasiyana

Kuti mupange mndandanda wa zokhazikika, lowetsani zinthu zake ndikuzitsekera muzitsulo zopindika. Mwachitsanzo, chithunzi chomwe chili pansipa chikuwonetsa gulu lomwe lili ndi zokhazikika 6:

={1;2;3;4;5;6}

Mndandanda woterewu ukhoza kugwiritsidwa ntchito mu Excel formulas. Mwachitsanzo, njira yotsatirayi ikuphatikiza zikhalidwe za gulu ili:

=СУММ({1;2;3;4;5;6})

Mafomuwa amatha kugwira ntchito zingapo nthawi imodzi. Mwachitsanzo, chilinganizo chotsatirachi chidzabweza mtengo wapamwamba womwe umabwera chifukwa chowonjezera mindandanda iwiri yamagulu:

=МАКС({1;2;3;4;5;6}+{7,8,9,10,11,12})

Mipikisano yosalekeza imatha kukhala ndi manambala, mawu, ma booleans, ndi zolakwika # N / A:

={12;"Текст";ИСТИНА;ЛОЖЬ;#Н/Д}

Mungakhale ndi funso lomveka bwino: N'chifukwa chiyani timafunikira mndandanda woterewu? Ndiyankha ndi chitsanzo.

Chitsanzo chogwiritsa ntchito mndandanda wa zosinthika mu Excel

Nambala yomwe ili pansipa ikuwonetsa mndandanda wa ophunzira omwe adalandira magiredi ena:

Ntchito yathu ndikutanthauzira kuwunika kuchokera ku manambala kupita ku kufotokozera kwapakamwa ndikuwonetsa zofananira pagulu C2:C7. Pankhaniyi, sizomveka kupanga tebulo lapadera kuti musunge zolemba za magiredi, kotero ndizopindulitsa kwambiri kupanga mndandanda wotsatirawu:

={"";"Неудовл.";"Удовл.";"Хорошо";"Отлино"}

Pankhaniyi, gawo loyamba la gululi lili ndi chingwe chopanda kanthu, chifukwa zimaganiziridwa kuti sipangakhale kuwunika kwa 1.

Kenako fomula yomwe imabweretsa zotsatira zomwe tikufuna idzawoneka motere:

Mu chitsanzo ichi, ntchito INDEX imabweretsanso mtengo wa chinthucho kuchokera kumagulu osiyanasiyana, malo omwe amaperekedwa ndi nambala ya ordinal (score).

Fomula iyi si njira yotsatirika, ngakhale ili ndi mndandanda. Chifukwa chake, mukalowa, ndikokwanira kukanikiza kiyi Lowani.

Zachidziwikire, titha kukopera fomulayi kumaselo ena onse ndikupeza zotsatira zomwe tikufuna:

Koma zingakhale zanzeru kugwiritsa ntchito fomula yama cell angapo. Zidzawoneka motere:

Titha kupita patsogolo ndikupereka mndandanda wa zosinthika dzina. Dzinali limaperekedwa chimodzimodzi monga momwe zimakhalira nthawi zonse, kudzera mu bokosi la zokambirana Pangani dzina:

Musaiwale kuphatikiza chizindikiro chofanana m'munda zosiyanasiyana, apo ayi Excel idzatenga mndandandawo ngati chingwe cholembera.

Tsopano fomulayi ikuwoneka ngati yowopsa kwambiri:

Monga mukuonera, nthawi zina zosakaniza zokhazikika zimakhala zothandiza kwambiri.

Chifukwa chake, muphunziro ili, mwadziwa zambiri zamagulu osiyanasiyana komanso kugwiritsa ntchito kwawo ku Excel. Kuti mumve zambiri za arrays, werengani zolemba zotsatirazi:

• Chiyambi cha mafomula osiyanasiyana mu Excel
• Mafomu a Multicell mu Excel
• Mafomu amtundu wa cell mu Excel
• Kusintha mitundu yosiyanasiyana mu Excel
• Kugwiritsa ntchito mitundu yosiyanasiyana mu Excel
• Njira zosinthira masanjidwe amitundu mu Excel