Iko IF basa inowedzera kugadzirisa mazano kune Excel spreadsheets kuburikidza nekuedza imwe mamiriro ezvinhu kuti uone kana ichokwadi kana nhema. Kana mamiriro acho ari echokwadi, basa racho richaita chimwe chiito. Kana iyo mamiriro acho ehema, ichaita chimwe chiito. Dzidza zvakawanda pamusoro peKANA basa pasi apa.
Kuita kuverenga nekupinda Dhiyabhorosi neIYO Basa
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .
Izwi rechirevo chebasa nderokuti:
= IF (test logic, kukoshesa kana chiri chokwadi, kukoshesa kana nhema)
Pfungwa yekufungidzira nguva dzose inofananidzwa pakati pemitemo miviri. Kuenzanisa operators kunoshandiswa, somuenzaniso, kuona kana kukosha kokutanga kwakawanda kupfuura kana kudarika kwechipiri, kana kuenzana nayo.
Somuenzaniso, mumufananidzo pano, test logic inofanidza mari yevashandi iri muchitsetse B kuti vaone kana iri huru kupfuura $ 30,000.00.
= IF (B2> 30000, B2 * 1%, 300)
Kana imwe nguva basa racho rakatarisa kana kuongorora kwemashoko kuri kwechokwadi kana kuti kwenhema, kunoita chimwe chezviito zviviri zvakataurwa nehuwandu kana chiri chechokwadi uye chinokosha kana zvikakavhirwe zvenhema.
Mhando dzezviito izvo basa rinogona kuita zvinosanganisira:
- kuita zviyero uchishandisa chirevo kana kupinda nhamba ye data
- kuratidza zvinyorwa zvinyorwa mumasero akaitwa mapepa,
- kusiya chikamu chechiso chisina chinhu.
Kuita kuverenga pamwe neIYO Basa
Iko IF basa rinogona kuita zviyero zvakasiyana zvichienderana kana basa rinodzoka kukosha kwechokwadi kana kwete.
Mumufananidzo wepamusoro, shanduro inoshandiswa kuverenga mari yekuderedza inobva kune vashandi vashandi.
= IF (B2> 30000, B2 * 1%, 300)
Dhaniro yekuderedzwa inotorwa achishandisa fomu yakapinda sechinhu chinokosha kana gakava rechokwadi . Nzira yacho inowedzera mitsva iri muchitsetse B ne1% kana mari yevashandi iri yakakura kudarika $ 30,000.00.
Kupinda Dhiyabhorosi neIYO Basa
Iyo IF IF function inogonawo kugadzirirwa kuisa nhamba yedata muchikamu chekutsvaga. Iyi dhesi inogona kushandiswa mune zvimwe zviyero.
Mumuenzaniso wepamusoro, kana mari yevashandi isingasviki $ 30,000.00, iyo inofanirwa kana nharo dzenhema dzakagadzirirwa kuisa purogiramu yakazara ye $ 300.00 nokuda kwekubviswa panzvimbo yekushandisa kuverenga.
Cherechedza: Hazvirevi dhora kana comma separator inopinda nenhamba 30000 kana 300 mubasa racho. Kupinda imwechete kana kuti zvose zvinokanganisa zvikanganiso.
- Excel inoshanda inoshandisa comma separarator pakati pemakakatanwa, saka kupinda ma commas nehamba kunotungamirira Excel mukutenda kuti zvinopfuura nhatu nharo dzakapindirwa nokuda kweAIF basa.
- Sezvo dhilar zviratidzo zvinyorwa, kupinda mukati mavo nenhamba kunotungamirira Excel mukutenda kuti kukanganisa kwekunyora kwakaitwa uye kunopa kuigadzirisa.
Kuratidza Nheyo Zvinyorwa kana Kusiya Maseji Asina kubhadhara neExcel IF Function
Kuratidza Mashoko kana Zvinyorwa Zvinyorwa zvine IF Function
Kuva nemashoko akashandiswa neAIP basa kunze kwekuti nhamba inogona kuita kuti zvive nyore kuwana uye kuverenga zvakananga mhinduro mumushandi webasa.
Mumuenzaniso wepamusoro, IF iyo basa rakagadzirirwa kuongorora kana vadzidzi vachitora bvunzo ye geography nenzira yakarurama vanoona maguta makuru kune nzvimbo dzakawanda muSouth Pacific.
Kuongorora kwemagariro eE IF basa kunofanidza mhinduro dzevadzidzi muchikamu B nemhinduro yakarurama yakapinda munyaya yacho pachayo.
Kana mhinduro yemudzidzi ichienzanisa nezita rakapinda mumagwaro ekunyora magwaro, shoko rakarurama rinoratidzwa munoramende C. Kana zita racho risina kufanana, sero harisi rakashaiwa.
= IF (B2 = "Wellington", "Kururamisa", "")
Kushandisa mazwi asina kukodzera kana zvinyorwa zvekutumira mune imwe NHA basa rimwe nerimwe rinopindira rinofanira kunge rakaiswa mumashoko akanyorwa, akadai se:
- chikonzero chekuongorora manzwiro: B2 = "Wellington"
- kukosha kana chokwadi chechokwadi "Chiruramisa"
Kusiya Maseji Asina Kubviswa
Sezvinoratidzwa kuti kukosha kana nharo dzenhema mumuenzaniso uri pamusoro apa, masero akasara asina kuvhara nokupinda mapeji asina zvinyorwa zvinyorwa ( "" ).