Imikorere "Niba" Muri Excel

Mubikorwa byinshi hamwe na Microsoft Excel ikora, ugomba guhitamo "niba" imikorere. Uyu ni umwe mubakoresha usubiza kenshi mugihe ukora imirimo muri gahunda. Reka duhangane nikihe kintu nuburyo bwo gukorana nayo.

Ibisobanuro rusange nimirimo

"Niba" ari ibintu bisanzwe bya Microsoft Excel. Inshingano zayo zirimo kugenzura imiterere yihariye. Iyo imiterere ikorwa (Ukuri), hanyuma mu Kagari, aho iyi mikorere ikoreshwa ni agaciro kamwe, kandi niba idakozwe (ibinyoma) - ikindi.

Syntax yiyi miterere niyi ikurikira: "Niba (imvugo yumvikana; [imikorere niba ukuri];

Urugero rwo gukoresha "niba"

Noneho reka dusuzume ingero zihariye aho formula hamwe na "niba" ikoreshwa.

1. Dufite ameza yimishahara. Abagore bose bashizeho premium kugeza 8 Werurwe mumafaranga 1000. Imbonerahamwe ifite inkingi aho hasi. Rero, dukeneye kubara abagore kurutonde rwatanzwe nurutonde no mumirongo ihuye na "igihembo kugeza 8 Werurwe" inkingi ya "1000". Mugihe kimwe, niba hasi bidahuye numugore, agaciro k'imigozi nk'izo igomba kuba ihuye "0". Imikorere izafata ubu bwoko: "Niba (B6 =" abagore. "; 1000"; "0") ". Ni ukuvuga, mugihe ibisubizo byikizamini ari "ukuri" (niba bigaragaye ko umugore ufite ibipimo "abagore" ari "1000", kandi niba "ikindi" Ibisobanuro, usibye "abagore."), kimwe, ibya nyuma - "0".
2. Twinjiye kuriyi mvugo muri selire nkuru, aho ibisubizo bigomba kwerekanwa. Mbere yo kuvuga, shyira ikimenyetso "=".



3. Nyuma yibyo, kanda urufunguzo rwa Enter. Noneho ko iyi formula igaragara muri selile yo hepfo, shyira gusa icyerekezo cyiburyo bwiburyo bwuzuye bwa selile yuzuye kandi, outa kuri buto yimbeba yibumoso kandi, usohore, ukoreshe indanga kugeza munsi yimbonerahamwe.



4. Twabonye rero ameza hamwe ninkingi yuzuyemo "niba" imikorere.

Urugero rwimikorere ifite ibintu byinshi

Muri "niba" imikorere, urashobora kandi kwinjira mubihe byinshi. Muri ibi bihe, umugereka wumukozi umwe "niba" ukoreshwa mubindi. Iyo imiterere ikorerwa mu kagari, ibisubizo byagenwe byerekanwe, niba imiterere idakozwe, ibisohoka biterwa numukoresha wa kabiri.

1. Kurugero, fata imbonerahamwe imwe hamwe no kwishyura igihembo cyo ku ya 8 Werurwe. Ariko iki gihe, ukurikije ibisabwa, ingano ya premirium iterwa numunyeshuri. Abagore bafite imiterere yabakozi nyamukuru bakira bonus ya marike 1000, kandi abakozi bafasha bahabwa amafaranga 500 gusa. Mubisanzwe, abagabo ntibabona ubu bwoko bwo kwishyura batitaye ku cyiciro.
2. Imiterere yambere nuko niba umukozi ari umugabo, noneho agaciro ka premium yakiriwe ni zeru. Niba iyi gaciro ari ibinyoma, kandi umukozi ntabwo ari umugabo (ni ukuvuga umugore), noneho ikizamini cyimiterere ya kabiri iratangira. Niba umugore yerekeza ku bakozi b'ingenzi, "1000" Agaciro kazerekanwa mu Kagari, kandi mu gihe kinyuranye - "500". Muri formula, bizasa nkibi: "= Niba (B6 =" umugabo. "; 0000"; 1000 ";"
3. Twinjije iyi mvugo kuri selile yo hejuru ya "Igihembo kugeza 8 Werurwe" inkingi.



4. Nkubushize, "kurambura" formula.

Urugero hamwe no kurangiza ibintu bibiri icyarimwe

Muri "niba" imikorere, urashobora kandi gukoresha "na" kugufasha gusoma mubyukuri ibikorwa bibiri cyangwa byinshi icyarimwe.

1. Kurugero, mubihe turimo, premium yo ku ya 8 Werurwe ku mafaranga 1000 ahabwa gusa abagore 1000 bahawe gusa n'abakozi b'ingenzi, n'abahagarariye abagabo n'abagore bagaragazwa n'abakozi b'abafasha ntibakiriwe. Mu buryo nk'ubwo agaciro muri kasho ka Igihembo kitari 1000, ni ngombwa kubahiriza ibintu bibiri: hasi ni igitsina gore, icyiciro cyabantu ni abakozi nyamukuru. Mubindi bihe byose, agaciro muriyi selile bizaba zeru. Ibi byanditswe na formula ikurikira: "= Niba (na (B6 =" abagore. "; C6 =" Abakozi b'ingenzi ");" 0000 "; Shyiramo mu kagari.



2. Gukoporora agaciro ka formula kuri selile hepfo, kimwe cyerekanwe muburyo hejuru.

Urugero rwo gukoresha umukoresha "cyangwa"

"Niba" imikorere ishobora kandi gukoresha "cyangwa" umukoresha. Bisobanura ko agaciro ari ukuri niba byibuze kimwe mubintu byinshi bikorwa.

1. Noneho rero, tuvuge ko premium bitarenze ku ya 8 Werurwe aringaniye 1000 gusa ku bagore bari mu bakozi bakuru. Muri uru rubanza, niba umukozi ari umugabo cyangwa yerekeza ku bakozi bafasha, ubwo igihembo cye kizaba zeru, naho ubundi - amafaranga 1000. Nka formula, isa nkiyi: "= Niba (B6 =" umugabo. "; C6 =" Abakozi b'abafasha ");" 1000 ")". Andika muri selire ikwiye.



2. "Kurambura" ibisubizo.

Nkuko mubibona, "niba" imikorere ishobora kuba umukoresha mwiza mugihe ukorana namakuru muri Microsoft Excel. Iragufasha kwerekana ibisubizo bihuye nibihe bimwe.