The "kana" iri Excel

Microsoft Excel Software chinhu simba mudziyo rinogona kukubatsira kugadzirisa zvakaoma matambudziko computational. Chimwe chezvinhu kushandiswa istrument ino yakatarwa iri kushanda "KANA".

kukosha mashandiro

Kana kushanda "Eksele" vanofanira kunzwisisa zvairehwa mashandiro "kana" kuvaka zvakarurama nemarongerwo queries. Nemhaka ayo algorithm kwakaita kuita inonzwisisika kuenzanisa, zvichienderana migumisiro izvo zvichashandiswa zvinoberekwa chimwe chezvinhu zviviri.

In zvakawanda nemashoko nyore, kuti "KANA" panyaya kukosha mashoko wechokwadi, anoita chimwe chiito iri chiitiko chenhema - mumwe. Panguva iyoyo sezvo chiito anogona kunge zvakajeka kukosha, uye mumwe basa, kusanganisira "KANA". With ichi mu "Excel" basa "kana" anobvumira bazi iri mabasa ane algorithm chiito kugadzirisa matambudziko akasiyana-siyana.

The nemarongerwo ari "kana"

A tsananguro nyore ruzhinji syntactic hurongwa - mumwe mukuru zvazvakanakira, riri inozivikanwa "Excel". The "KANA" rinorevawo nokuwanda - mushure guru iri mumabhuraketi anoratidza humwewo ezvinhu, chiito wechokwadi mupfungwa, uye ipapo panguva isiri. Schematically rinotsvaka sezvizvi:

KANA (log_vyrazhenie; [value_if_true] [value_if_false]);

nesting

Mumwe zviri chinosiyanisa mashandiro "kana" - iri nested. Ndiko, mukati chete mamiriro angava mumwe, kukosha iyo inoenderana zvinonyatsorehwa Zvaizobuda chikumbiro. Kuwedzera mashandiro mukati "kana" kungava vamwe. Asi chokutanga kana, chikamu ichi chinogona iri chero zvikamu vatatu nemarongerwo.

mamiriro akawanda

Pakubata mabasa akaoma, shandisa "KANA" ane ezvinhu shoma, zvisinei, panguva ino ruzhinji vanoshandisa pane dambudziko. Izvi imhaka chaiyo basa mnogouslovnosti algorithm. Basa iri Excel "KANA" tarisa mumwe chete kuenzanisa kushanda nenzira inonzwisisika okuti, kureva, kushandisa pachiimbwa kana disjunction hakushandi. Kuti mumuedze nokuti ezvinhu akawanda vanofanira kushandisa pfuma nesting.

Kuti tinzwisise sei kuisa ezvinhu anoverengeka mu "KANA", zviri nyore kushandisa muenzaniso. Ngatitii tinoda kuongorora kana nhamba muchitokisi "A1" munguva - kubva 5 kusvika 10. Sezvinogona kuoneka, muchiitiko ichi zvakafanira kuongorora maviri ezvinhu kuburikidza vachiongorora pamusoro kururama kwemashoko fananidzo maviri tsika - 5 uye 10. Kuti dzika muenzaniso uyu mu "Eksele", unofanira kunyora mashandiro sezvinotevera:

= IF (A1> 5; KANA (A1 <10; "zvaisanganisira mu kuwanda" "haisi mukati siyana") "haasi mukati siyana")

Kuti tidzivise vakawanda kudzokororwa goho mutongo vanofanira kushandisa nheyo nesting zvakare, ive nharo nokutaura pakuongorora kudzoka tsika mitambo, zvichienderana kupi uye zvibereko goho, kana pakutanga kushandiswa "uye" kubatanidza ose ezvinhu kamwe. Izvi zvinoomesa magadzirirwo kunzwisisa zvakanyorwa pane imwe duku dhigiri vakuru vakuru, asi vakawanda ezvinhu, izvi zvaizova Zvakanyanya Kunaka Panguva Yepamuviri.

Special shanda mikana

Zvinofanira kucherechedzwa kuti mashandiro "kana" kunoita kuti kusiya chinhu chimwe kana wandei parameters ayo. Panyaya iyi, migumisiro achavaponesa chii nharo kunge akadarikira ne user.

Kana panzvimbo inonzwisisika mashoko kusiya chinhu, mugumisiro mashandiro achaita chiito chiri kukonzera kuurayiwa venhema algorithm. Chikonzero ichi ndechokuti chirongwa kuwadzana chinhu pamwe zero, izvo zvinoreva kuti uri mutauro musoro "VENHEMA". Kana iwe siya chinhu chimwe tsika, basa Implementation panyaya chokwadi kana kuti nhema, zvino kana iwe wasarudza tichava "0".

Tinofanirawo vanotaurawo nyaya kana pane inonzwisisika mashoko asina akasuma vavake akadzorera ukoshi "CHOKWADI" kana "VENHEMA", uye chine vatambi, kana foni bhuku. Kana apo pane parameter rakanyorwa mashoko ine chinhu vamwe pane nhamba ukoshi kana musoro mashoko, achaita chikanganiso panguva aurayiwe. Kana iwe kutaridzwa Kero sero kana kunyoresa imwe nhamba / musoro kukosha, mugumisiro achasarudza zvirimo. Kamwe muchitokisi, kana mune ezvinhu nhamba 0 kuchinzi, shoko "venhema" kana chinhu, zvinoguma venhema mashandiro. Mune zvimwe zviitiko zvose, ita zvechokwadi chiito manyorero.

Kana tichishanda pamwe Chirungu shanduro "Excel" unofanira kufungawo chokwadi inoshanda vose uyewo akanyorwa Chirungu. Panyaya iyi mashandiro "KANA" chichange kunyorwa sezvinoita KANA, asi vamwe nemarongerwo uye algorithm nemabasa vacharamba chete.

Zvaunofanira kuteerera

"Excel" anobvumira kusvika 64 Sub-mabasa "KANA" - mari iyi kwakakwanira zvachose mabasa ose, zvisinei, kunyange iri nhamba duku kakawanda kunova dambudziko nokuda user. Pane zvikonzero zvinoverengeka: paaisika mumwe mubvunzo, nyore zvakakwana kuti kururama pamwechete nzira Kurekodha - Statistically, ose kuchangotanga inaccuracy muna 25% nyaya kunotungamirira kururama zvabuda, kuti yakakura chakarurama zvakakwana.

Imwe zvakaipira munhu nesting guru "KANA" chinhu yakaderera kuverenga. Pasinei ruvara kuparadzana chirongwa zvimwe zvikamu mubvunzo kunyanya nested kushanda, izvo zvakaoma zvikuru kuita kunze. Saka, kana pashure penguva achafanira kudzokera akagadzira kana kutanga kushanda womumwe chikumbiro, zvichava kusiya nguva yakawanda ari kunzwisisa kurekodha. Uyezve, mumwe nomumwe basa rine yayo peya pamusoro mumabhuraketi, uye netsaona vakaiisa panzvimbo yayo, vachafanira kutarisa kure kuti kutadza.

mienzaniso

Kusimbisa kunzwisisa mari, vari tsika, kufunga kuti mashandiro ari "KANA" muna Excel. Mienzaniso pazasi inoratidza dzose dzinokosha nzira kushandiswa kwayo.

The nyore muenzaniso nokuda kuongorora mashandiro ari kuenzanisa nhamba mbiri. Nokuti variability ichiwanikwa, tinorondedzera zviviri kusanganiswa tsika pakati variables ari mumasero A1 uye B1, uye izvo kuenzaniswa. Kuti vagadzirise dambudziko iri, tinofanira kushandisa nhoroondo fomu:

= IF (A1 = B1; "nhamba vakaenzana;" "dzisakarurama nhamba").

Panyaya iyi, pamberi chete ukoshi mumasero vose, zvinoguma zvakanyorwa "vakaenzana", mune zvimwe zviitiko zvose - "nhamba dzisakarurama".

Kudzokorora basa Zvimiso okuti pamwe ezvinhu akawanda, nenzira muenzaniso zvinogona kushandiswa kuwana nhamba zvinogadzirisa ane quadratic mukana wokuti vanhu vanga. Panyaya iyi, check unoitwa pamusoro discriminant - kana zviri zvishoma pane razero, saka hapana mhinduro kana razero - iri rimwe, mune zvimwe zviitiko zvose - pane midzi maviri. Kunyora izvi ezvinhu, zvakakwana kuti chikumbiro kuna zvinotevera:

Nokuti vaya vanoda kunzwisisa ose features, vane mashandiro "kana", muna Excel mienzaniso vari bhuku chikamu, izvo akatsanangura zvakadzama nzira chisarudzo neimwe.