Namhlanje sixelela malunga umsebenzi umhleli Excel spreadsheet, "Ukuba." It inento yokwenza amathuba ubhalo isicelo. Oku kunganxulunyaniswa weyona misebenzi ethandwa ngexesha lokusebenza.
Iimpawu eziphambili
Ngo-Excel, ifomula "Ukuba 'kunceda ukwenza zonke iintlobo zemisebenzi xa ufuna ukwenza uthelekise ezinye iinkcukacha ze ufumane yoko. Le isisombululo kwenza kube lula ukusebenzisa eyayizalwa algorithms, kwaye udale umthi isigqibo.
imizekelo yokusetyenziswa
Umsebenzi sijongeka njengoku: = IF (umsebenzi; ayinyaniso; amanga). Into yokuqala - amazwi nengqondo. Kungaba kwibinzana okanye inombolo. Umzekelo, "10" okanye "ngaphandle" - kuyinto libinzana esengqiqweni. Le eyesibini iparameter ukuba kungaqeshwa. Inyaniso - lixabiso ukuba ivela njenge yoko, ukuba binzana kuyinyaniso. Balala - i data eza kukhutshwa xa kuya kuba oluchanekileyo umsebenzi.
parameters ukulingana ezimbini iiseli
Ukuze siqonde imisebenzi kunokwenzeka "Ukuba 'ukuya Excel, imizekelo nje kuyimfuneko, kwaye ngoko siqhubela phambili ukuwafunda. Kwangena iiseli C1 bana 8 Ngokubhekele phaya, ibhokisi kwi D1 kungene ilandelayo ifomula: = IF (C1 <10; 1; 2). Ngenxa yoko, inkqubo iya thelekisa ixabiso parameter iiseli C1 10. Xa ungaphantsi kwe ezilishumi, intsimi livela kwi dilesi unit D1. Kungenjalo, umhleli iya kubonisa inani 2. Cinga enye ingxaki. Kukho uluhlu labafundi kunye namanqaku abo wafumana uzihlole. Ezi zilandelayo: 5, 4 no-3 no 2. Imiqathango ingxaki kubandakanya ukudalwa ngasinye abafundi umbhalo wokuphawula "ugqithiselwe" okanye "hayi badlula". Ngamanye amazwi, ukuba umfundi ihlelwe emithathu phezulu, yena kakuhle iimviwo. Ukuba isikolo sakhe ngaphantsi 3 - umfundi abazange baphumelele. Ukusombulula le ngxaki asinibhaleli le fomyula ilandelayo: = IF (C1 <3; "hayi icebo", "badlula"). Excel iya kuqalisa ukuthelekisa iziphumo ngamnye abafundi. Xa inkomba ngaphantsi kwesithathu (okt ezimbini) kwibhokisi efanelekileyo iya kuboniswa izimvo "zange akhulule." Ukuba score - 3 nangaphezulu, ibhokisi efunekayo uya kuphawula ukuba umfundi badlula uviwo. Umbhalo wokuphawula kufuneka uhlale ukhankanye nkqo. Ngokutsho Umgaqo enjalo imisebenzi elula Excel ifomyula "Ukuba". Ngexesha ukusetyenziswa kwayo, kunokwenzeka ukuba isicelo baqhubi uthelekiso hlobo: <> =,>, <,> =, <=.
Imizekelo nokusebenzisa i "OKANYE" iimeko "I"
Siyaqhubeka ukuziqhelisa kakuhle ingqiqo isicelo. Excel umhleli spreadsheet umsebenzi "Ukuba 'zinokudityaniswa baqhubi uthelekiso. Ezi parameters: "OR", "AND". Cacisa imeko ezifunekayo Excel: ukuba umfundi amanqaku alinganayo okanye ngaphantsi kwe-5, kodwa ngaphezulu kwe-3 kufuneka kuboniswa izimvo: "abapasileyo". Ngenye indlela - ". Kungekho" Ngoko ke, uwele kuphela abo bafundi abafumene ezintlanu ezine. umsebenzi Record ezifanayo kumhleli table usebenzisa ifomula okhethekileyo. Kuya kukhangela ngolu hlobo: = IF (AND (A1 <= 5; A1> 3); "abapasileyo", "hayi"). Ukuze ufumane imizekelo ezintsonkothileyo kubandakanya ukusetyenziswa i "OKANYE" okanye "NO". Ngoko ke, makhe sibone indlela yokusebenzisa indlela ukuya Excel, ukuba kukho inani iimeko le ngxaki. Umzekelo amazwi anjalo; = UKUBA (OKANYE (A1 = 5; A1 = 10); 100; 0). Kulo kulandela ukuba xa isalathisi kwi iseli A1 ngu 5 okanye 10, le nkqubo ubonisa isiphumo 100 kwimeko esahlukileyo - 0. ungasebenzisa ezi abasebenzayo kunye ukusombulula imisebenzi enzima kakhulu. Umzekelo, i-database kuyimfuneko ukubala abanamatyala abafuna kuhlawula ngaphezulu kwe 10,000 engange. Nakuba kunjalo, ukuba ngaba uhlawule imali ngaphezu kweenyanga ezintandathu. Umsebenzi Excel umhleli spreadsheet, "Ukuba" ikuvumela ukuba bamakishe ngokuzenzekelayo malunga amagama ezichaphazelekayo "client ngxaki". Masithi kuseli A1 data ibekwe ebonisa ityala lexesha elide (iinyanga). ifildi B1 ubonisa imali. Kulo mzekelo, ifomula iza kuba ngolu hlobo lulandelayo: UKUBA = (I (A1> = 6; B1> 10000); "client ngxaki"; ""). Oku kulandela ukuba xa umntu kwafunyanwa oluhambelana iinqobo amiselweyo, le nkqubo iya kubonisa phambi igama lakhe izimvo oyifunayo. Kuba bonke abanye abathathi soluhlu iseli efanayo kuhlala ayinanto. Cinga nje ngomzekelo ka kwimeko apho imeko lubalulekile. Faka izimvo ezifanelekileyo. Ngenxa yoko, ifomula kungaba ngolu hlobo: = UKUBA (OKANYE (A1> = 6; B1> 10000); "imeko amanqam", ""). Kulo mzekelo, ukuba inkqubo ifumana umdlalo ubuncinane omnye parameters (ixesha, imali amatyala), umsebenzisi uya kubona inowuthi ahambelanayo. Kule meko yokuqala, umyalezo "client ngxaki" wakhutshwa kuphela xa ziphunyeziwe zombini iimeko ezichaziweyo.
umsebenzi High-level entsonkothileyo
Umsebenzi Excel umhleli spreadsheet, "Ukuba 'lisetyenziswa yokucima ngesiphoso eyakhelwe-ngaphakathi xa ifan'ba zero, kwakunye kwezinye iimeko eziliqela. Imeko yokuqala iboniswe umhleli njenge "DIV / 0" yaye yinto eqhelekileyo. Idla khona kwiimeko apho ndlela inokuba ukhutshelwe «A / B», apho icandelo B kwi iiseli ngamnye ngu zero. Oku baqa- umqhubi ukuba uqhagamshelane ingxelo. Ngoko ke, le ndlela iya kuba yimfuneko ukuba le fom zilandelayo: UKUBA = (B1 = 0; 0; A1 / B1). Oku kulandela ukuba iseli B1 izaliswe i parameter "zero", umhleli iya kukhupha "0", kungenjalo yahlula Excel component A1 ukuya data B1 ezigunyazisiweyo isiphumo.
isaphulelo
Ukuziqhelisa, kaninzi kwenzeka kwaye imeko, nto leyo eza kuxoxwa kamva. Kumalunga yokubala izaphulelo, ngokusekelwe kwi-mali iyonke imali echithwa nokufunyanwa kweempahla ezithile. Esetyenzisiweyo kulo mzekelo, isizalo sinokuba le fomu ilandelayo: ubuncinane 1000 - 0%; 1001-3000 - 3%; 3001-5000 - 5%; ngaphezulu kwe-5001 - 7%. Cinga ngemeko apho kukho ledatha Excel zeendwendwe, kunye neenkcukacha malunga imali abayichitha ekuthengeni asethi. Ngoku kufuneka ukuba ukubala isaphulelo kumntu ngamnye. Ukulungiselela le njongo, sisebenzisa ibinzana zilandelayo :. = IF (A1> = 5001; B1 * 0,93; IF (A1> = 3001; B1 * 0,95; ..) Le nkqubo sijonga imali liphelele loko kuthengiweyo xa udlula inani ngo-5001. engange, xa iphinda phindiweyo ngo-93 ekhulwini ixabiso leempahla. xa wokoyisa uphawu ka 3001 unit, kukho nemiphumo efanayo, kodwa kuthathelwa ingqalelo i-95%. le fomyula ingentla lula ukubeka abalufumeneyo. umthamo yentengiso kunye nezaphulelo izalathi ebekwe yi ngumsebenzisi.
Ukusetyenziswa iifitsha ezichazwe kunokwenzeka ukuba isisombululo iingxaki ezahlukahlukeneyo. The main Isigaba - ukulungiselela olufanelekileyo kwifomula ukuba ungafumani isiphumo engalunganga. Ke kaloku, ukuba uyazi ukuba mawuzisebenzise njani umqhubi ku Excel, ukuba kukho inani iimeko le ngxaki.