Kubvisa nhamba muExcel

Pakati pese arithmetic mashandiro, mana makuru anogona kusiyaniswa: kuwedzera, kuwanda, kupatsanura uye kubvisa. Iyo yekupedzisira ichakurukurwa munyaya ino. Ngatitarisei nzira dzipi dzaungaite chiitiko ichi muExcel.

nzira yekubvisa

Kubvisa muExcel kunogona kusanganisira ese ari maviri manhamba chaiwo uye maseru ane manhamba.

Chiito chacho pachacho chinogona kuitwa uchishandisa fomula inotanga nechiratidzo “zvakaenzana” ("=") Zvadaro, maererano nemitemo yemasvomhu, tinonyora pakati peusiku, shure kwaizvozvo ndakaisa chiratidzo “bvisa” ("-") uye panoperera ratidza subtrahend. Mune mafomula akaoma, panogona kunge paine akati wandei ma subtrahends, uye mune iyi kesi, anotevera, uye pakati pavo anoiswa "-". Nokudaro, tinowana chigumisiro nenzira yekusiyana kwenhamba.

Kuti uwane kujekeswa, ngatitarisei maitiro ekubvisa uchishandisa chaiwo mienzaniso pazasi.

Muenzaniso 1: Musiyano Wenhamba Dzakananga

Ngatitii tinoda kuwana mutsauko pakati penhamba chaidzo: 396 na 264. Unogona kuita zvekubvisa uchishandisa fomula iri nyore:

1. Isu tinopfuudza kune sero yemahara yetafura yatinoronga kuita masvomhu anodiwa. Tinodhinda chikwangwani mairi "=", mushure mezvo tinonyora chirevo: =365-264.
2. Mushure mekunge formula yataipa, dzvanya kiyi pinda uye tinowana mhedzisiro inodiwa.

Cherechedza: Ehe, chirongwa cheExcel chinogona kushanda nenhamba dzisina kunaka, saka, kubvisa kunogona kuitwa mune reverse order. Muchiitiko ichi, fomula inotaridzika seiyi: =264-365.

Muenzaniso 2: kubvisa nhamba kubva musero

Zvino zvatafukidza musimboti uye muenzaniso wakapfava wekubvisa muExcel, ngationei nzira yekubvisa imwe nhamba kubva musero.

1. Semune nzira yekutanga, tanga wasarudza sero remahara kwatinoda kuratidza mhedzisiro yekuverenga. Mariri:
   • tinonyora chiratidzo "=".
   • tsanangura kero yesero umo minuend iripo. Iwe unogona kuita izvi nemaoko nekuisa makonisheni uchishandisa makiyi pane keyboard. Kana kuti unogona kusarudza sero yaunoda nekudzvanya pairi nebhatani rekuruboshwe.
   • wedzera chiratidzo chekubvisa kune formula ("-").
   • nyora subtrahend (kana paine akati wandei ma subtrahends, wedzera iwo kuburikidza nechiratidzo "-").
2. Mushure mekudzvanya kiyi pinda, tinowana chigumisiro muchitokisi chakasarudzwa.

Cherechedza: muenzaniso uyu unoshandawo mukurongeka, kureva kana minuend iri nhamba chaiyo, uye subtrahend ndiyo kukosha kwenhamba musero.

Muenzaniso 3: musiyano pakati penhamba mumaseru

Sezvo muExcel isu, kutanga kune zvese, tinoshanda nehunhu mumaseru, ipapo kubvisa, kazhinji, kunofanirwa kuitwa pakati peiyo nhamba data mavari. Matanho acho anenge akafanana neakatsanangurwa pamusoro apa.

1. Isu tinosimuka muchitokisi chinoguma, mushure mezvo:
   • isa chiratidzo "=".
   • zvakafanana nemuenzaniso 2, tinoratidza sero rine yakaderedzwa.
   • nenzira imwecheteyo, wedzera sero ine subtrahend kune formula, usingakanganwe kuwedzera chiratidzo pamberi pekero yayo. “bvisa”.
   • kana paine akati wandei achabviswa, wedzera mumutsara nechiratidzo "-" mberi.
2. Nokudzvanya kiyi pinda, tichaona mhedzisiro muformula cell.

Muenzaniso 4: Kubvisa imwe koramu kubva kune imwe

Matafura, sezvatinoziva, ane data zvakachinjika (makoramu) uye akatwasuka (mitsetse). Uye kazhinji zvinodikanwa kuti uwane mutsauko pakati peiyo nhamba data iri mumakoramu akasiyana (maviri kana anopfuura). Uyezve, zvinodikanwa kuita otomatiki iyi nzira kuti usapedze nguva yakawanda pabasa iri.

Chirongwa chinopa mushandisi mukana wakadaro, uye heino maitirwo angaitwa:

1. Enda kusero rekutanga rekoramu yatinoronga kuita masvomhu. Isu tinonyora fomu yekubvisa, ichiratidza kero dzemasero ane minuend uye subtrahend. Muchiitiko chedu, izwi rinotaridzika seizvi: =С2-B2.
2. Dhinda kiyi pinda uye kuwana musiyano wenhamba.
3. Inoramba ichingoita otomatiki kubvisa kune asara maseru ekoramu nemhedzisiro. Kuti uite izvi, fambisa chinongedzo chembeva kukona yezasi yekurudyi yesero neformula, uye mushure mekunge chiratidzo chekuzadza chaonekwa muchimiro chechiratidzo cheblack plus, bata pasi bhatani rekuruboshwe uye woridhonza kusvika kumagumo kwekoromo. .
4. Patinongoburitsa bhatani rembeva, maseru ekoramu anozadzwa nemhedzisiro yekubvisa.

Muenzaniso 5: Kubvisa nhamba chaiyo kubva mukoramu

Mune zvimwe zviitiko, iwe unoda kubvisa imwechete chaiyo nhamba kubva kumaseru ese ari mukoramu.

Iyi nhamba inogona kungotsanangurwa mufomula. Ngatitii tinoda kubvisa nhamba kubva pachikamu chekutanga chetafura yedu 65.

1. Isu tinonyora fomura yekubvisa musero repamusoro-soro rekoramu inobuda. Muchiitiko chedu, zvinoita seizvi: =A2-65.
2. Mushure mekutora pinda musiyano ucharatidzwa muchitokisi chakasarudzwa.
3. Tichishandisa mubato wekuzadza, tinokwevera fomula kune mamwe masero mukoramu kuti tiwane mhedzisiro yakafanana mavari.

Zvino ngatitorei kuti tinoda bvisa nhamba chaiyo kubva kumaseru ese ekoramu, asi haizongoratidzwa chete muchimiro, asi ichave zvakare yakanyorwa musero chairo.

Kubudirira kusina mubvunzo kweiyi nzira ndeyokuti kana tichida kuchinja nhamba iyi, zvichava zvakakwana kuti isu tichinje panzvimbo imwe - muchitokisi chine iyo (mune yedu, D2).

Iyo algorithm yezviito munyaya iyi ndeyotevera:

1. Enda kune yepamusoro sero yekoramu yekuverenga. Isu tinonyora mairi yakajairika yekubvisa formula pakati pemasero maviri.
2. Kana iyo formula yagadzirira, usamhanye kudzvanya kiyi pinda. Kuti ugadzirise kero yesero ine subtrahend paunenge uchitambanudza fomula, unofanirwa kuisa zviratidzo zvakatarisana nemarongero ayo. “$” (nemamwe mazwi, ita kuti kero yesero ive yakakwana, nekuti nekusarudzika zvinongedzo muchirongwa zvine hukama). Iwe unogona kuita izvi nemaoko nekuisa mavara anodiwa mufomula, kana, kana uchiigadzirisa, fambisa cursor kukero yesero ine subtrahend uye wodzvanya kiyi kamwe chete. F4. Nekuda kweizvozvo, iyo formula (mune yedu kesi) inofanirwa kutaridzika seizvi:
3. Mushure mekunge fomula yanyatsogadzirira, tinya pinda kuwana mhedzisiro.
4. Tichishandisa mucherechedzo wekuzadza, tinoita kuverenga kwakafanana mumaseru asara ekoramu.

Cherechedza: Muenzaniso uri pamusoro unogona kutariswa mune reverse order. Avo. bvisa kubva kune imwechete cell data kubva kune imwe column.

mhedziso

Nekudaro, Excel inopa mushandisi akasiyana siyana ezviito, nekuda kweiyo masvomhu akadaro sekubvisa anogona kuitwa nenzira dzakasiyana, izvo, zvechokwadi, zvinokutendera kuti utsungirire basa rechero kuoma.