Ukukhipha izinombolo ku-Excel

Phakathi kwayo yonke imisebenzi ye-arithmetic, ezine eziyinhloko zingahlukaniswa: ukuhlanganisa, ukuphindaphinda, ukuhlukanisa nokukhipha. Lokhu kwakamuva kuzoxoxwa ngakho kulesi sihloko. Ake sibheke ukuthi yiziphi izindlela ongayenza lesi senzo ku-Excel.

inqubo yokukhipha

Ukukhipha ku-Excel kungabandakanya kokubili izinombolo ezithile namaseli aqukethe amanani ezinombolo.

Isenzo ngokwaso singenziwa kusetshenziswa ifomula eqala ngophawu "kuyalingana" ("="). Khona-ke, ngokwemithetho ye-arithmetic, sibhala kancane, ngemva kwalokho ngibeke uphawu "khipha" ("-") bese ekugcineni ukhombise subtrahend. Kumafomula ayinkimbinkimbi, kungaba nama-subtrahends amaningana, futhi kulokhu, ayalandela, futhi phakathi kwawo abekwe "-". Ngakho, sithola umphumela ngendlela umehluko izinombolo.

Ukuze uthole ukucaca okwengeziwe, ake sibheke ukuthi kwenziwa kanjani ukususa usebenzisa izibonelo ezithile ngezansi.

Isibonelo 1: Umehluko Wezinombolo Ezithize

Ake sithi sidinga ukuthola umehluko phakathi kwezinombolo ezithile: 396 kanye 264. Ungenza ukususa usebenzisa ifomula elula:

1. Sidlulela esitokisini samahhala setafula lapho sihlela ukwenza izibalo ezidingekayo. Siphrinta uphawu kuyo "=", ngemva kwalokho sibhala inkulumo ethi: =365-264.
2. Ngemva kokuthi ifomula ibhaliwe, cindezela inkinobho Faka futhi sithola umphumela odingekayo.

Qaphela: Vele, uhlelo lwe-Excel lungasebenza ngezinombolo ezingezinhle, ngakho-ke, ukususa kungenziwa ngokulandelana. Kulokhu, ifomula ibonakala kanje: =264-365.

Isibonelo sesi-2: ukukhipha inombolo kuseli

Manje njengoba sesimboze umgomo kanye nesibonelo esilula kakhulu sokususa ku-Excel, ake sibone indlela yokukhipha inombolo ethile kuseli.

1. Njengendlela yokuqala, khetha kuqala iseli yamahhala lapho sifuna ukuveza umphumela wokubala. Kuyo:
   • sibhala uphawu "=".
   • cacisa ikheli leseli lapho i-minuend itholakala khona. Ungakwenza lokhu ngokwenza ngokufaka izixhumanisi usebenzisa okhiye kukhibhodi. Noma ungakhetha iseli oyifunayo ngokuchofoza kuyo ngenkinobho yegundane engakwesokunxele.
   • engeza uphawu lokususa kufomula ("-").
   • bhala i-subtrahend (uma kukhona ama-subtrahend ambalwa, wengeze ngophawu "-").
2. Ngemva kokucindezela ukhiye Faka, sithola umphumela kuseli ekhethiwe.

Qaphela: lesi sibonelo futhi sisebenza ngokulandelana kokuhlehla, okungukuthi uma i-minuend iyinombolo ethile, futhi i-subtrahend iyinani lezinombolo kuseli.

Isibonelo sesi-3: umehluko phakathi kwezinombolo kumaseli

Njengoba ku-Excel thina, okokuqala, sisebenza ngamanani kumaseli, khona-ke ukususa, imvamisa, kufanele kwenziwe phakathi kwedatha yezinombolo kuwo. Izinyathelo zicishe zifane nalezi ezichazwe ngenhla.

1. Sivuka esitokisini esiwumphumela, ngemuva kwalokho:
   • beka uphawu "=".
   • ngokufanayo nesibonelo 2, sibonisa iseli eliqukethe okuncishisiwe.
   • ngendlela efanayo, engeza iseli eline-subtrahend kufomula, ungakhohlwa ukwengeza uphawu phambi kwekheli lalo. "khipha".
   • uma kukhona okuningana okumele kukhishwe, wengeze ngokulandelana ngophawu "-" phambili.
2. Ngokucindezela inkinobho Faka, sizobona umphumela kuseli lefomula.

Isibonelo sesi-4: Ukukhipha ikholomu kwenye

Amathebula, njengoba sazi, aqukethe idatha kokubili ngokuvundlile (amakholomu) nangokuqondile (imigqa). Futhi ngokuvamile kuyadingeka ukuthola umehluko phakathi kwedatha yezinombolo equkethwe kumakholomu ahlukene (amabili noma ngaphezulu). Ngaphezu kwalokho, kuyinto efiselekayo ukwenza le nqubo ngokuzenzakalelayo ukuze ungachithi isikhathi esiningi kulo msebenzi.

Uhlelo lunikeza umsebenzisi ithuba elinjalo, futhi nansi indlela engenziwa ngayo:

1. Iya kuseli lokuqala lekholomu lapho sihlela ukwenza khona izibalo. Sibhala ifomula yokukhipha, ebonisa amakheli amaseli aqukethe i-minuend kanye ne-subtrahend. Esimweni sethu, inkulumo ibonakala kanje: =С2-B2.
2. Cindezela inkinobho Faka futhi uthole umehluko wezinombolo.
3. Kuhlala kuphela ukwenza ngokuzenzakalelayo ukukhipha kwamaseli asele ekholomu ngemiphumela. Ukuze wenze lokhu, hambisa i-pointer yegundane ekhoneni elingezansi kwesokudla seseli ngefomula, futhi ngemva kokuthi umaka wokugcwalisa uvele ngesimo sophawu olumnyama lokuhlanganisa, cindezela inkinobho yegundane kwesokunxele bese uyihudulela ekupheleni kwekholomu. .
4. Lapho nje sikhulula inkinobho yegundane, amaseli ekholomu azogcwaliswa ngemiphumela yokukhipha.

Isibonelo sesi-5: Ukukhipha inombolo ethile kukholamu

Kwezinye izimo, ufuna ukususa inombolo efanayo kuwo wonke amaseli kukholamu.

Le nombolo ingashiwo kalula kufomula. Ake sithi sifuna ukususa inombolo kukholamu yokuqala yethebula lethu 65.

1. Sibhala ifomula yokukhipha kuseli eliphezulu kakhulu lekholomu ewumphumela. Esimweni sethu, kubonakala kanje: =A2-65.
2. Ngemuva kokuchofoza Faka umehluko uzovezwa kuseli ekhethiwe.
3. Sisebenzisa isibambo sokugcwalisa, sihudulela ifomula kwamanye amaseli kukholamu ukuze sithole imiphumela efanayo kuwo.

Manje ake sithi sifuna khipha inombolo ethile kusuka kuwo wonke amaseli wekholomu, kodwa ngeke nje ikhonjiswe kufomula, kodwa futhi izoba ebhalwe ngeseli ethile.

Inzuzo engangabazeki yale ndlela ukuthi uma sifuna ukushintsha le nombolo, kuyokwanela ukuthi siyishintshe endaweni eyodwa - esitokisini esiqukethe (kithi, i-D2).

I-algorithm yezenzo kuleli cala imi kanje:

1. Iya kuseli eliphezulu kakhulu lekholomu ukuze uthole izibalo. Sibhala kuyo ifomula evamile yokususa phakathi kwamaseli amabili.
2. Uma ifomula isilungile, ungajahi ukucindezela ukhiye Faka. Ukuze ulungise ikheli leseli nge-subtrahend lapho welula ifomula, udinga ukufaka izimpawu ngokuphambene nezixhumanisi zayo. “$” (ngamanye amazwi, yenza ikheli leseli liphelele, njengoba ngokuzenzakalelayo izixhumanisi ohlelweni zihlobene). Ungakwenza lokhu mathupha ngokufaka izinhlamvu ezidingekayo kwifomula, noma, uma uyihlela, hambisa ikhesa ekhelini leseli elinombhalo ongaphansi bese ucindezela inkinobho kanye. F4. Ngenxa yalokho, ifomula (kithi) kufanele ibukeke kanje:
3. Ngemuva kokuthi ifomula isilungile ngokuphelele, chofoza Faka ukuthola umphumela.
4. Sisebenzisa umaka wokugcwalisa, senza izibalo ezifanayo kumaseli asele ekholomu.

Qaphela: Isibonelo esingenhla singacatshangelwa ngokulandelana okuphambene. Labo. khipha kudatha yeseli efanayo kwenye ikholomu.

Isiphetho

Ngakho-ke, i-Excel inikeza umsebenzisi izenzo eziningi ezihlukahlukene, ngenxa yokuthi ukusebenza kwe-arithmetic njengokukhipha kungenziwa ngezindlela ezihlukahlukene, okuyinto, vele, ikuvumela ukuba ubhekane nomsebenzi wanoma yikuphi ukuyinkimbinkimbi.