I "ukuba" ku Excel

Microsoft Excel software sisixhobo esinamandla aya kukunceda ukuba ucombulule iingxaki ezinzima azo. Enye istrument ezininzi ezisetyenziswayo kakhulu awumiselayo ngumsebenzi of "UKUBA".

ixabiso lomsebenzi

Xa usebenza "Eksele" kufuneka baqonde ukubaluleka umsebenzi "ukuba" ukwakha imibuzo echanekileyo syntax. Ngenxa algorithm yawo ayenza ukwenza uthelekiso ubhalo, kuxhomekeke kwiziphumo eziya kuveliswa enye yezi zinto zimbini.

Ngokomthetho okulula, i "UKUBA 'kwimeko inyaniso yexabiso ibinzana, isebenzise isenzo single xa kuthe ubuxoki - omnye. Ngelo xesha elinye nenyathelo kunokuba nokuba inani ecacileyo, yaye umsebenzi othile, kuquka i "UKUBA". Xa oku "Excel" umsebenzi "ukuba" ivumela yesebe yokusebenza algorithm kwamanyathelo ekusombululeni iingxaki ezahlukahlukeneyo.

Le syntax "ukuba"

Inkcazo olulula uninzi izakhiwo syntactic - enye okulungileyo, nto idume "Excel". I "IF" ibhekisela ngangenani lazo - emva igama kwizibiyeli abonisa imeko enye, inyathelo ngengqiqo oyinyaniso, waza emva koko kwi-engalunganga. Ngokwalo kukhangeleka ngolu hlobo:

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

yokwakha

Enye iimpawu leyo eyenza umsebenzi "ukuba" - ukuba ifakwe. Oko kukuthi, ngaphakathi isakhiwo esifanayo inokuba omnye, xabiso lazo elo ke kuxhomekeke kwiziphumo yonke isicelo. Ukongeza umsebenzi ngaphakathi 'ukuba' inokuba abanye. Kodwa kwimeko yokuqala, eli candelo kungenziwa akhiwe ngayo nayiphi na nxalenye abathathu lwesivakalisi.

iimeko ezimbalwa

Xa usebenza imisebenzi enzima, sebenzisa "UKUBA" kunye iimeko ezimbalwa, nangona kunjalo, ngeli xesha uninzi kubasebenzisi kukho ingxaki. Oku kungenxa algorithm umsebenzi mnogouslovnosti ethile. Umsebenzi in Excel "UKUBA" khangela ukusebenza enye kuphela uthelekisa kwindawo ibinzana ingqiqo, oko kukuthi, ukuba usebenzise isihlanganisi okanye disjunction akusayi kusebenza. Ukuvavanya ukuba iimeko ezininzi kufuneka ukusebenzisa yokwakha propati.

Ukuze siqonde ukubeka indlela iimeko ezininzi "UKUBA", kulula ukusebenzisa i umzekelo. Masithi ufuna ukukhangela ukuba ngaba kufunyenwe inani esiseleni "A1" kwi yothuba elithile - ukususela As 5 ukuya kwi-10 zingabonakala, kule meko kuyimfuneko ukuhlola iimeko ezimbini ngokujonga malunga nokusebenza yesifaniso neenqobo ezimbini - 5 no 10. Ukuze kuphunyezwe lo mzekelo ku "Eksele", kufuneka ubhale umsebenzi ngolu hlobo lulandelayo:

= IF (A1> 5; IF (A1 <10; "ziqukwe kuluhlu" "ayikho ngaphakathi kuluhlu") "ayikho ngaphakathi kuluhlu")

Ukunqanda isigwebo uphindaphindo output ezininzi kufuneka asebenzise umgaqo yokwakha kwakhona, njengoko ingxabano ngokujonga amaxabiso ukubuya imisebenzi, kuxhomekeke ekubeni kuphi kwaye ukuvelisa imveliso, okanye ekuqaleni yosetyenziso "yaye" yokudibanisa kuyo zonke iimeko ngaxeshanye. Le ndlela nzima ebhaliweyo kwinqanaba encinane kwiqela elinegunya ukuqonda yoyilo, kodwa kukho inani elininzi iimeko, le ndlela iya kuba eliphezulu kakhulu.

ongakhetha umsebenzi Special

Kufuneka kuqatshelwe ukuba umsebenzi "ukuba" ikuvumela ukuba ushiye ezingenanto enye okanye ezininzi parameters zayo. Kulo mzekelo, iziphumo ziya kuxhomekeka koko iimpikiswano azifakwanga ngumsebenzisi.

Ukuba endaweni amabinzana ubhalo ashiye into engento, ngesiphumo umsebenzi enze isenzo leyo inoxanduva uphumezo lobuxoki algorithm. Isizathu soku kukuba le nkqubo ukunxulumana isithuba engenanto ngeqanda, nto leyo ethetha ukuba ulwimi ubhalo "FALSE". Ukuba ushiya kunengenanto lamanani, onoxanduva ukuphunyezwa kwimeko kuyinyaniso okanye bubuxoki, ngoko xa ukhetha umphumo iya kuba "0".

Kufuneka kwakhona ukhankanye ityala xa kokuyilwayo endaweni ibinzana ubhalo ithe yaziswa ubuyisela ixabiso "TRUE" okanye "FALSE", kunye uluhlu abalinganiswa, okanye kweseli. Kwimeko apho kukho iparameter elibhaliweyo ibinzana equlethe into ngaphandle kokuba ixabiso lenani okanye amagama ubhalo, loo nto iya kunokubangela imposiso ngexesha abulawe. Ukuba awukhankanyi idilesi iseli okanye ukubhalisa inani elithile ixabiso / ubhalo, umphumo uya kumisela umxholo. Xa esiseleni, okanye imeko-0 kubhaliwe kwathiwa, igama elithi "obuxoki" okanye engenanto, isiphumo bubuxoki umsebenzi. Kuzo zonke ezinye iimeko, yenza inyathelo real script.

Xa sisebenza kunye noguqulelo IsiNgesi "Excel" kufuneka ithathele ingqalelo into yokuba yonke imisebenzi nabo abhalwe IsiNgesi. Kulo mzekelo umsebenzi "UKUBA" aya kurekhodwa njengoko XA, kodwa abanye lwesivakalisi kunye nemisebenzi algorithm iya kuhlala injalo.

Oko kufuneka sinikele ingqalelo

"Excel" ivumela ukuya kwi sub-imisebenzi 64 "UKUBA" - esi sixa lukwanele phantse yonke imisebenzi, Noko ke, nkqu eli inani elincinane kaninzi kuye kube nzima ukuba umsebenzisi. Kukho izizathu ezininzi: xa ekudaleni umbuzo, zilula ngokwaneleyo ukuba impazamo kunye Ukurekhoda ifomula - manani, yonke inaccuracy incinane-25% amatyala kukhokelela kwiziphumo ezingachanekanga, oko kukuthi Isalathisi esikhulu ngokwaneleyo.

Enye engxakini yokwakha enkulu "UKUBA" i sofundo eliphantsi. Nangona inkqubo umbala yokuzahlula ezinye iindawo yombuzo ngakumbi ekwiseli imisebenzi, apho kunzima kakhulu ukwenza phandle. Ngoko ke, ukuba emva Kuza kubakho ixesha uye emva kuyilo okanye ukuqala ukusebenza kunye nesicelo somnye umntu, oko kuya kushiya ixesha elininzi ekuqondeni ukurekhoda. Ukongeza, umsebenzi nganye isibini eyeyalo izibiyeli, yaye ngempazamo uyibeke endaweni yayo, kuya kufuneka bajonge kakhulu imposiso.

izibonelo

Ukuqinisa ukuqonda iindleko, xa kusenziwa, ukuba siqwalasele indlela umsebenzi yi "UKUBA" e-Excel. Le mizekelo ingezantsi ibonisa zonke iindlela ezisisiseko ukusetyenziswa kwayo.

Umzekelo elula uhlalutyo msebenzi ukuthelekisa amanani amabini. Kuba Ukwahluka kokufumaneka, thina ezichaza amaxabiso ezimbini ngamanani yezahlukileyo iiseli A1 kunye B1, kwaye leyo iza kuthelekiswa. Ukusombulula le ngxaki, kufuneka sithathe ithuba rhekhodo ya ifomu:

= IF (A1 = B1; "amanani bayalingana;" "inani olungalinganiyo").

Kulo mzekelo, ubukho nexabiso efanayo zombini iiseli, umphumo uba irekhodi "zilingana", kuzo zonke ezinye iimeko - 'inani ukungalingani ".

Ukujongisisa umsebenzi ingxelo enemiqathango kunye neemeko ezininzi, ngendlela umzekelo ingasetyenziswa ukufumana inani izisombululo ze i'quadratic equation. Kulo mzekelo, itshekhi senziwe kwi discriminant - ukuba libengaphantsi kunonothi, ngoko akukho izisombululo ukuba zero - yenye, kuzo zonke ezinye iimeko - kukho iingcambu ezimbini. Ukurekhoda le meko, kwanele ukuba enze isicelo kulandelayo:

Kwabo bafuna ukuqonda ngcono zonke iimpawu, banayo umsebenzi "ukuba", e-Excel mizekelo kwicandelo reference, leyo ichazwe ngokwenkcukacha indlela ngesigqibo ngamnye kubo.