Maanta waxaan u sheegi ku saabsan shaqo ee editor isbiriidhshiit Excel, "Haddii." Waxay leedahay in la sameeyo fursadaha macquul ah codsiga. Waxaa loo saarin karaa in hawlaha ugu caansan inta lagu jiro hawlgalka.
Features Key
In Excel, formula ah "haddii" waxay ka caawisaa si ay u qabtaan oo dhan cayn kasta oo hawlaha marka aad rabto in aad is barbar xogta qaar ka mid ah oo aad hesho natiijo. xal Taasi waxay suurto gal in ay isticmaalaan branching algorithms, iyo in la abuuro geed go'aan.
tusaale u ah isticmaalka
function waxay noqonaysaa sidan: = HADDII (hawsha, run, been ah). element ugu horeysay ee - hadal macquul ah. Waxaa laga yaabaa in weedh ama tiro. Tusaale ahaan, "10" ama "laga saaray" - waa hadal macquul ah. Halbeegga Tani waxaa loo baahan yahay in la buuxiyo. Xaq - waa qiimaha muuqata iyada oo sababtu tahay, haddii hadal run ah. Jiifso - xogta ah in la soo saari doonaa marka hawsha sax ma noqon doonto.
beegyada uu Sinnaanta laba unugyada
Si loo fahmo hawlaha suurto galka ah ee "haddii" in Excel, tusaalooyin ah si fudud loo baahan yahay, ka dibna waxaan u guurto on in ay iyaga ka fiirsan. Dawadu unugyada fahmi C1 8. dheeraad ah, sanduuqa at D1 waxaa galay ka dib markii formula: = HADDII (C1 <10; 1, 2). Sidaas darteed, barnaamijka barbardhigi doona qiimaha unugyada C1 dhimaya 10. Marka ay ka yar tahay toban, beer muuqataa on D1 unit cinwaanka. Haddii kale, editor muujin doonaa tirada 2. Ka fikir dhibaato kale. Waxaa jira liiska ardayda iyo tirooyinka ay ka heli on imtixaanka. Kuwani waa sida soo socota: 5, 4 iyo 3 iyo 2. The xaaladaha dhibaatada ku lug leedahay abuurista kasta oo ardayda comment text a "maray" ama "aan maray". In si kale loo dhigo, haddii ardayga la qiimeeyo saddex iyo ilaa, uu guuleysto imtixaanka. Haddii uu gool ka hooseeyo 3 - ardayga aan ku gudbin. Si loo xalliyo dhibaatada this inaynu u qorno formula soo socda: = HADDII (C1 <3; "ma tashaday", "maray"). Excel bilaabi doonaan in ay is barbar natiijada kasta oo ka mid ah ardayda. Marka index uu ka yar yahay saddex (ie, laba) ee sanduuqa ku habboon la sheegi doonaa comment "ma samatabbixiyo." Haddii score ah - 3 iyo wixii ka sareeya, sanduuqa loo baahan yahay calaamadee doonaa in ardayga uu maray imtixaanka. Text comments waa in aad had iyo jeer u sheeg in xigashooyin. Sida ay mabda 'sida hawlaha fudud Excel formula "Haddii". Inta lagu jiro ay la isticmaalo, waxaa suurtagal ah si aad u dalbato ka shaqeeya la barbardhigo sida: <> =,>, <,> =, <=.
Tusaalooyinka lagu dabaqaayo "AMA" shuruudo "I"
Waxaan sii wadi in ay ku dhaqmaan oo u yaqaaniin macquulka ah ee codsiga. Excel function editor isbiriidhshiit "Haddii" waxaa la dhigan kara shaqeeya barbardhigo. Kuwani waa xadka: "AMA", "IYO". Sheeg xaalad loo baahan yahay in Excel, haddii bartaha goolal siman yahay ama uu ka yar 5, laakiin in ka badan 3 waa in loo soo bandhigo comment: "baas". Haddii kale - ". Lahayn" Sidaas, u gudbin oo kaliya kuwa ardayda helay shan iyo afar. hawsha la mid ah Record in editor miiska la isticmaalayo karaan formula gaar ah. Waxay u ekaan doontaa sidan oo kale: = HADDII (AND (A1 <= 5, A1> 3), "baas", "maya"). Wixii tusaalooyin dheeraad ah oo adag waxaa ka mid ah isticmaalka ah "AMA" ama "IYO". Sidaas aan aragno sida loo codsado formula si Excel, haddii tiro ka mid ah xaaladaha dhibaatada. Tusaale ka mid ah hadal noocaas ah: = HADDII (AMA (A1 = 5, A1 = 10), 100, 0). Laga soo bilaabo tan u socota in haddii tilmaanta in A1 cell waa 5 ama 10, barnaamij soo bandhigayaa natiijada 100 kiiskan ka soo horjeeda - 0. isticmaali kartaa ka shaqeeya, kuwaas oo si ay u xalliyaan hawlaha badan oo adag. Tusaale ahaan, database ee loo baahan yahay si ay u xisaabiso qaamaysan ee u baahan in ay bixiso wax ka badan 10,000 oo rubles. Si kastaba ha ahaatee, iyagu ma ay deynta ka badan lix bilood. Function editor isbiriidhshiit Excel, "Haddii" kuu ogolaanaya in aad si toos ah u xusaan soo horjeeda magacyada kala "macmiilka dhibaatada". Ka soo qaad in gacanta A1 xogta ku yaal oo muujinaya deynta dheer (bilood). beerta B1 bandhigayaa lacagta. Xaaladdan oo kale, formula wuxuu noqon doonaa sida soo socota: HADDII = (I (A1> = 6, B1> 10000); "Dhibaatada macmiilka", ""). Taas waxaa raacda in haddii qof la helay in kulan shuruudaha khaaska ah, barnaamijka tusi doonaa hore ee magiciisa comment doonayo. Maxaa yeelay, dhammaan ka qaybgalayaasha kale ee liiska cell la mid ah ayaa weli madhan. Ka fiirso tusaale ahaan kiiska halkaas oo xaaladda ay tahay mid muhiim ah. Ku qor comment ku habboon. Sidaas darteed, caanaha u ekaan kartaa sidan: = HADDII (AMA (A1> = 6, B1> 10000); "xaalad adag", ""). Xaaladdan oo kale, haddii barnaamijka helaa kulan ugu yaraan mid ka mid ah xuduudaha (waqtiga, lacagta daynta), user ay arki doonaan note u dhigma. In xaaladda ugu horeysay, fariinta "macmiilka dhibaato" la soo saaray oo kaliya marka ay labada shuruudaha ku qeexan ayaa la kulmay.
heerka sare ee dhibaato kakanaanta
Function editor isbiriidhshiit Excel, "Haddii" waxaa loo isticmaalaa in garab qaladka dhisay-in marka qaybinaya by eber, iyo sidoo kale xaaladaha kale oo dhowr ah. Xaaladda koowaad waxaa la tilmaamay by editor sida "QAY / 0" waa wax caadi ah. Waxaa si caadi ah u soo baxdo xaaladaha halkaas oo caanaha la koobiyeyn karaa «A / B», kuna waari dhexdeeda qayb B ee unugyada shaqsi waa eber. Tani waxaa looga fogaan karaa by operator inaad la xiriirto warbixintan. Sidaas darteed, caanaha loo baahan yahay waxay noqon doontaa in ay leeyihiin qaab soo socda: HADDII = (B1 = 0; 0, A1 / B1). Taas waxaa raacda in haddii B1 cell waxaa ka buuxsamay dhimaya "eber" ah, editor soo saari doonaa "0", haddii kale qaybin Excel A1 qayb xogta B1 iyo bandhigayaa natiijada.
dhimis
In dhaqanka, inta badan waxay dhacdaa iyo xaaladda, taas oo laga wada hadli doonaa ka dib. Waxaa ku saabsan xisaabinta dhimis, oo ku salaysan cadadka guud ee lacagta lagu bixiyey iibka badeecadaha qaarkood waa. Waxaa loo adeegsaday in kiiskan, furta oo yeelan karaan foomka soo socda: ugu yaraan 1000 - 0%; 1001-3000 - 3%; 3001-5000 - 5%; in ka badan 5001 - 7%. Ka fikir xaaladda ay jirto database Excel ah ee soo booqda, iyo sidoo kale macluumaad ku saabsan xaddiga ay ku bixisay on iibka hantida. Hadda waxaan u baahan tahay si ay u xisaabiso dhimis ah ee macmiil kasta. Ujeedada this, waxaan isticmaali ra'yi soo socda :. = HADDII (A1 ah> = 5001; B1 * 0,93; HADDII (A1> = 3001; B1 * 0,95; ..) Nidaamka wuxuu hubinayaa in wadarta guud ee iibsadaan marka ay badato tirada ee 5001. rubles, waxaa lagu dhuftay 93 boqolkiiba qiimaha badeecadda. lacala gudbo sumadda 3001 unit, waxaa jira saameyn la mid ah, laakiinse iyada oo la tixgelinayo 95% ah. The qaaciidooyinka kor ku xusan si fudud loo gelin karaa tababar. mugga ee iibka iyo qiimo dhimis tilmaamayaasha dhigay by user ah.
Isticmaalka sifooyinka lagu sharaxay waa suuragal ah in xalka dhibaatooyinka kala duwan. yada ugu weyn ee - diyaarinta sax ah oo caanaha si aan u hesho natiijo qaldan. Hadda oo aad ogtahay sida loo isticmaalo farsamayaqaanka si uu Excel, haddii tiro ka mid ah xaaladaha dhibaatada.