The "ngati" mu kupambana

Microsoft kupambana mapulogalamu ndi chida champhamvu chimene chingatithandize kuthetsa zovuta mavuto zowerengera. Mmodzi wa istrument kwambiri ntchito ya akonzedwa ili ndi ntchito ya "NGATI".

phindu la kugwira ntchito

Pamene ntchito mu "Eksele" ayenera kumvetsa tanthauzo la ntchito ya "ngati" yomanga mafunso zolondola malembedwe. Ndiyamika aligorivimu ake anachita kuchita nkhani poyerekeza, malingana ndi zotsatira za zomwe opangidwa ndi zinthu ziwiri.

Mawu osavuta kwambiri, ndi "NGATI" mu nkhani ya phindu lenileni la mawu ndi, udzapereka chinthu limodzi likhoza onama - wina. Pa nthawi yomweyo monga kanthu kungakhale kapena kufunika zolaula, ndi ntchito zina, kuphatikizapo "NGATI". Ndi ichi "kupambana" ntchito "ngati" amalola nthambi mu ntchito ya aligorivimu kanthu pothetsa mavuto osiyanasiyana.

The malembedwe ya "ngati"

Kumasulira yosavuta ambiri a nyumba syntactic - mmodzi mwa ubwino waukulu, umene uli wotchuka chifukwa "kupambana". The "NGATI" limanenanso chiwerengero chawo - pambuyo nfundo yaikhulu m'mabokosi limasonyeza chikhalidwe taphunzira, kanthu m'njira owona, ndiyeno pa cholakwika. Schematically izo zikuwoneka ngati izi:

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

kukaikira mazira

Chimodzi mwa zinthu chimene chimasiyanitsa ntchito ya "ngati" - izo zinapeza malo okhala. Ndiko kuti, mkati dongosolo Zingakhalenso wina, mtengo wa potsata zotsatira wonse wa pempholo. Kuwonjezera ntchito mkati mwa "ngati" mwina ena. Koma m'nkhani yoyamba, zikuluzikulu izi zikhoza ili chilichonse cha magawo atatu a malembedwe a.

zinthu zingapo

Polimbana ndi zinthu zovuta ntchito "ngati" ndi zinthu zochepa Komabe, panthawi imeneyi ambiri owerenga pali vuto. Ichi ndi chifukwa mndandanda ntchito mnogouslovnosti aligorivimu. Ntchito mu kupambana "NGATI" onani chimodzi chokha poyerekeza ntchito mu mawu zomveka, ndiye kuti ntchito akamaimba kapena disjunction sizigwira ntchito. Kuyesa zinthu angapo kugwiritsa ntchito katundu kukaikira mazira.

Kumvetsa mmene kukhazikitsa zinthu zingapo "NGATI", ndi yabwino ntchito chitsanzo. Tiyerekeze tikufuna kufufuza ngati chiwerengero mu cell "A1" mu nthawi anapatsidwa - 5 mpaka 10. Monga mmene taonera, mu nkhani iyi m'pofunika kufufuza zinthu ziwiri ndi kuona n'loonadi poyerekeza ndi makhalidwe awiri - 5 ndi 10. Kuti kukhazikitsa chitsanzo mu "Eksele", muyenera kulemba ntchito motere:

= NGATI (A1> 5; NGATI (A1 <10; "m'gulu osiyanasiyana" "si mwa uthunthu") "si mwa uthunthu")

Kupewa angapo kubwerezabwereza linanena bungwe chiganizo ayenera kutsatira mfundo za kukaikira mazira kachiwiri, monga mkangano poona kubwerera makhalidwe ntchito, malingana ndi kumene ndi kutulutsa linanena bungwe, kapena pa chiyambi cha ntchito "ndi" kaphatikizidwe kuti zinthu zonse mwakamodzi. Njira imeneyi complicates kapangidwe kumvetsa olembedwa pa mlingo wochepa mu utsogoleri wolowezana, koma ndi ambiri ndithu zinthu, njira imeneyi angafune mulingo woyenera.

Zosintha Special ntchito

Tikumbukenso kuti ntchito ya "ngati" limakupatsani kusiya kanthu imodzi kapena angapo magawo ake. Pankhaniyi, zotsatira kudzadalira zimene mfundo sizinawonetsedwe ndi wosuta.

Ngati m'malo mwa mawu zomveka kusiya opanda chifukwa cha ntchito ya adzachita amachitila amene ali ndi udindo kuphedwa zonama za aligorivimu ndi. Chifukwa cha ichi ndi chakuti dongosolo kusonkhana malo opanda kanthu ndi ziro, kutanthauza kuti pa chilankhulo zomveka "ZONYENGA". Mukasiya mmodzi kanthu makhalidwe, udindo kukhazikitsa zinachitikira zoona kapena zabodza, ndiye pamene inu kusankha zotsatira zake zidzakhala "0".

Tiyenera kutchura choncho m'malo akuti n'zomveka si anayambitsa kumanga akubwerera phindu "ZOONA" kapena "ZONYENGA",, komanso chikhalidwe, kapena kutchula selo. Ngati kumene chizindikiro ndi kwalembedwa kuwonetsera munali chinachake osati mtengo n'zosangalatsa kumva mawu kapena zomveka, izo adzachititsa kulakwitsa pa kuphedwa. Ngati inu mwachindunji adiresi ya foni kapena kulembetsa nambala inayake ya mtengo / n'zomveka, chifukwa adzaona zili. Kamodzi muchipindachi, kapena chikhalidwe cha anthu 0 kwalembedwa, mawu akuti "wabodza" kapena kanthu, chifukwa ndi zabodza kugwira ntchito. Nthawi zina zonse, kuchita script kanthu kwenikweni.

Pamene ntchito ndi Baibulo English "kupambana" ayenera kuganizira mfundo yakuti ntchito zonse komanso m'Chichewa. Pankhaniyi kugwira ntchito "ngati" ulembedwa ngati NGATI, koma ena malembedwe ndi ntchito aligorivimu sizinasinthe.

Kodi muyenera kulabadira

"Kupambana" amalola kuti 64 kum'mwera ntchito "ngati" - ndalamazo chikukwanira pafupifupi ntchito zonse Komabe, ngakhale nambala ka kawirikawiri vuto kwa wosuta. Pali zifukwa zingapo: polenga kafufuzidwe ndi chosavuta zokwanira kuonedwa ndi chilinganizo Kujambula - powerengera, aliyense inaccuracy pang'ono 25% milandu zimabweretsa zotsatira yolondola, kuti ndi opondapo chizindikiro.

sangathe wina wa kukaikira mazira lalikulu "NGATI" ndi otsika aziwakonda. Ngakhale pulogalamu mtundu kulekana m'madera ena a funso kwambiri ntchito Mathithiŵa, amene ali ovuta kwambiri kuti kunja. Choncho, ngati patapita kanthawi adzapita ku kamangidwe kapena kuyambitsa ntchito ndi pempho wina, izo adzasiya nthawi yambiri pa kumvetsa kujambula. Komanso, aliyense ntchito ali awiri yakeyake m'mabokosi, ndipo mwangozi anaika pamalo ake, kuyang'ana kutali wa cholakwa.

zitsanzo

Kulimbitsa kumvetsa ndalama, kuchita, kuganizira m'mene ntchito ndi "NGATI" mu kupambana. Zitsanzo m'munsimu kusonyeza njira zonse zoyambirira za ntchito yake.

Chitsanzo losavuta kwa kusanthula ntchito ndi kufanana kwa manambala awiri. Pakuti masiyanidwe a kupezeka, tingamasulire mfundo ziwiri n'zosangalatsa kumva za zosintha mu maselo A1 ndi B1, ndi amene adzakhale poyerekeza. Kuti athetse vutoli, ife tiyenera kugwiritsa ntchito umboni wa mawonekedwe:

= NGATI (A1 = B1; "manambala zimakhala zofanana;" "wosiyana chiwerengero").

Pankhaniyi, pamaso pa mtengo womwewo maselo onse, chifukwa uli umboni "ofanana", nthawi zina onse - "chiwerengero cha wosiyana".

Kubwerezanso ntchito mawu makonzedwe ndi zinthu angapo, mwa chitsanzo angagwiritsidwe ntchito kupeza chiwerengero cha njira ya aone kuti pali quadratic. Pankhaniyi, cheke pa tsiku discriminant wa - ngati zosakwana ziro, ndiye palibe njira ngati ziro - ndi chimodzi, nthawi zina onse - pali mizu awiri. Kulemba chikhalidwe ichi, ndi okwanira kupempha otsatirawa:

Amene akufuna kumvetsa bwino mbali zonse, amene ntchito ya "ngati", mu kupambana zitsanzo mu chigawo limanena, omwe anafotokoza mwatsatanetsatane Inde a chigamulo cha aliyense wa iwo.