Kuchotsa manambala mu Excel

Pakati pa ntchito zonse za masamu, zazikulu zinayi zitha kusiyanitsa: kuwonjezera, kuchulukitsa, kugawa ndi kuchotsa. Nkhani yomalizayi tikambirana m’nkhani ino. Tiyeni tiwone njira zomwe mungachitire izi mu Excel.

ndondomeko kuchotsa

Kuchotsa mu Excel kungaphatikizepo manambala ndi ma cell omwe ali ndi manambala.

Zomwezo zitha kuchitidwa pogwiritsa ntchito njira yomwe imayamba ndi chizindikiro "zofanana" ("="). Kenako, molingana ndi malamulo a masamu, timalemba mphindi, pambuyo pake ndinaika chizindikiro "kuchotsa" ("-") ndipo pamapeto asonyeze subtrahend. M'njira zovuta, pakhoza kukhala ma subtrahends angapo, ndipo apa amatsatira, ndipo pakati pawo amaikidwa "-". Choncho, timapeza zotsatira mu mawonekedwe a kusiyana kwa manambala.

Kuti timveke bwino, tiyeni tiwone momwe tingachotsere pogwiritsa ntchito zitsanzo zili pansipa.

Chitsanzo 1: Kusiyana kwa Nambala Zachindunji

Tiyerekeze kuti tifunika kupeza kusiyana pakati pa manambala enieni: 396 ndi 264. Mutha kuchotsa pogwiritsa ntchito njira yosavuta:

1. Timadutsa ku selo yaulere ya tebulo momwe timakonzekera kuwerengera zofunikira. Timasindikiza chikwangwani mmenemo "=", pambuyo pake timalemba mawu akuti: =365-264.
2. Pambuyo polemba fomula, dinani batani Lowani ndipo timapeza zotsatira zofunika.

Zindikirani: Zachidziwikire, pulogalamu ya Excel imatha kugwira ntchito ndi manambala oyipa, chifukwa chake, kuchotsa kumatha kuchitidwa motsatana. Pankhaniyi, fomula ikuwoneka motere: =264-365.

Chitsanzo 2: kuchotsa nambala m’selo

Tsopano popeza tafotokoza mfundo komanso chitsanzo chosavuta chochotsera mu Excel, tiyeni tiwone momwe tingachotsere nambala inayake kuchokera mu cell.

1. Monga njira yoyamba, choyamba sankhani selo laulere kumene tikufuna kusonyeza zotsatira za kuwerengera. M'menemo:
   • timalemba chizindikiro "=".
   • tchulani adilesi ya selo yomwe minuend ilipo. Mungathe kuchita izi pamanja polowetsa zogwirizanitsa pogwiritsa ntchito makiyi pa kiyibodi. Kapena mutha kusankha cell yomwe mukufuna podina ndi batani lakumanzere.
   • onjezerani chizindikiro chochotsa ku fomula ("-").
   • lembani subtrahend (ngati pali ma subtrahends angapo, onjezani kudzera pachizindikiro "-").
2. Pambuyo kukanikiza kiyi Lowani, timapeza zotsatira mu selo losankhidwa.

Zindikirani: chitsanzo ichi chimagwiranso ntchito motsatira ndondomeko, mwachitsanzo, pamene minuend ili nambala yeniyeni, ndipo subtrahend ndi mtengo wa nambala mu selo.

Chitsanzo 3: kusiyana pakati pa manambala m'maselo

Popeza mu Excel ife, choyamba, timagwira ntchito ndi zikhalidwe m'maselo, ndiye kuchotsa, nthawi zambiri, kuyenera kuchitika pakati pa ziwerengero zomwe zilimo. Masitepewo ali pafupifupi ofanana ndi amene tafotokozazi.

1. Timadzuka mu cell yomwe ikubwera, pambuyo pake:
   • ikani chizindikiro "=".
   • mofanana ndi chitsanzo 2, timasonyeza selo yomwe ili ndi yochepetsedwa.
   • momwemonso, onjezani cell yokhala ndi subtrahend ku formula, osaiwala kuwonjezera chizindikiro patsogolo pa adilesi yake. "kuchotsa".
   • ngati alipo angapo oti achotsedwe, onjezani motsatana ndi chizindikiro "-" patsogolo.
2. Mwa kukanikiza kiyi Lowani, tiwona zotsatira zake mu formula cell.

Chitsanzo 4: Kuchotsa ndime imodzi pa ina

Matebulo, monga tikudziwira, ali ndi data yopingasa (migawo) komanso yosunthika (mizere). Ndipo nthawi zambiri pamafunika kupeza kusiyana pakati pa manambala omwe ali m'magawo osiyanasiyana (awiri kapena kuposerapo). Kuphatikiza apo, ndikofunikira kupanga izi zokha kuti musawononge nthawi yambiri pa ntchitoyi.

Pulogalamuyi imapatsa wogwiritsa mwayi wotero, ndipo nayi momwe angagwiritsire ntchito:

1. Pitani ku selo loyamba la gawo lomwe tikukonzekera kuwerengera. Timalemba njira yochotsera, kusonyeza maadiresi a maselo omwe ali ndi minuend ndi subtrahend. M'malo athu, mawuwa akuwoneka motere: =С2-B2.
2. Dinani fungulo Lowani ndi kupeza kusiyana kwa manambala.
3. Zimangokhala kuti zingopanga zokha kuchotsa kwa maselo otsala a mzati ndi zotsatira. Kuti muchite izi, sunthani cholozera cha mbewa kumunsi kumanja kwa selo ndi fomula, ndipo chizindikiro chodzaza chikawoneka ngati chizindikiro chakuda, gwirani batani lakumanzere ndikulikokera kumapeto kwa gawolo. .
4. Tikangomasula batani la mbewa, maselo amtundu adzadzazidwa ndi zotsatira za kuchotsa.

Chitsanzo 5: Kuchotsa nambala inayake pagawo

Nthawi zina, mukufuna kuchotsa nambala yeniyeni kuchokera ku maselo onse pamzere.

Nambala iyi ikhoza kufotokozedwa mu fomula. Tiyerekeze kuti tikufuna kuchotsa nambala kuchokera pagawo loyamba la tebulo lathu 65.

1. Timalemba fomula yochotsa mu selo lapamwamba kwambiri la mzere wotsatira. M'malo athu, zikuwoneka ngati izi: =A2-65.
2. Pambuyo kuwonekera Lowani kusiyana kudzawonetsedwa mu cell yosankhidwa.
3. Pogwiritsa ntchito chogwirira chodzaza, timakokera chilinganizocho kupita ku ma cell ena mugawo kuti tipeze zotsatira zofananira mwa iwo.

Tsopano tiyeni tiyerekeze kuti tikufuna chotsani nambala yeniyeni kuchokera m'maselo onse a mzati, koma sizidzawonetsedwa mu ndondomeko, komanso zidzakhala zolembedwa mu selo linalake.

Ubwino wosakayikitsa wa njirayi ndikuti ngati tikufuna kusintha nambala iyi, zidzakhala zokwanira kuti tisinthe pamalo amodzi - mu cell yomwe ili nayo (kwa ife, D2).

The algorithm ya zochita mu nkhani iyi ndi motere:

1. Pitani ku selo lapamwamba kwambiri lazambiri kuti muwerenge. Timalemba mmenemo njira yochotsera pakati pa maselo awiri.
2. Fomuyo ikakonzeka, musathamangire kukanikiza kiyi Lowani. Kuti mukonze adilesi ya cell ndi subtrahend potambasula chilinganizocho, muyenera kuyika zizindikiro moyang'anizana ndi makonzedwe ake. "$" (mwanjira ina, pangani adilesi yam'manja kukhala yokwanira, popeza mwachisawawa maulalo a pulogalamuyi amakhala achibale). Mutha kuchita izi pamanja polemba zilembo zofunika mu fomula, kapena, mukaikonza, sunthani cholozera ku adilesi ya cell ndi subtrahend ndikusindikiza batani kamodzi. F4. Zotsatira zake, chilinganizo (mwathu) chiyenera kuwoneka motere:
3. Pambuyo pokonzekera kwathunthu, dinani Lowani kuti apeze zotsatira.
4. Pogwiritsa ntchito chikhomo chodzaza, timawerengera zofanana m'maselo otsala a mzerewu.

Zindikirani: Chitsanzo pamwambapa chikhoza kuganiziridwa motsatira ndondomeko. Iwo. Chotsani deta yamtundu womwewo kuchokera pagawo lina.

Kutsiliza

Chifukwa chake, Excel imapatsa wogwiritsa ntchito zosiyanasiyana, chifukwa chake masamu ngati kuchotsa amatha kuchitidwa m'njira zosiyanasiyana, zomwe, zomwe, zimakupatsani mwayi wothana ndi zovuta zilizonse.