Momwe Mungachotsere Nambala mu Excel - Zitsanzo 5 Zothandiza

Utumiki wa Microsoft Excel spreadsheet nthawi zambiri umagwiritsidwa ntchito kukonza deta mumtundu wa manambala ndikuwerengera. Kuchotsa ndi imodzi mwazinthu zoyambira masamu, palibe kuwerengera komwe kungathe kuchita popanda izo. Pali njira zingapo zophatikizira ma cell a subtractive patebulo, iliyonse yomwe idzakambidwe mwatsatanetsatane pansipa.

Momwe mungachotsere ntchito mu Excel

Kuchotsa mu tebulo ndi chimodzimodzi pa pepala. Mawuwa ayenera kukhala ndi minuend, subtrahend, ndi chizindikiro "-" pakati pawo. Mutha kuyika minuend ndi subtrahend pamanja kapena kusankha ma cell omwe ali ndi datayi.

Tcherani khutu! Pali chikhalidwe chimodzi chomwe chimasiyanitsa kuchotsa mu Excel ndi ntchito yabwinobwino. Ntchito iliyonse mu pulogalamuyi imayamba ndi chizindikiro chofanana. Ngati simuyika chizindikirochi pamaso pa mawu opangidwa, zotsatira zake sizidzawonekera mu selo lokha. Pulogalamuyi idzawona zomwe zalembedwa ngati zolemba. Pachifukwa ichi, ndikofunikira nthawi zonse kuyika chizindikiro "=" poyambira.

Ndikofunikira kupanga chilinganizo ndi chizindikiro cha "-", fufuzani kulondola kwa kusankha kwa ma cell kapena kulowetsa manambala ndikudina "Enter". Mu cell momwe chilinganizocho chinalembedwera, kusiyana kwa manambala awiri kapena kuposerapo kumawonekera nthawi yomweyo. Tsoka ilo, palibe njira yochotsera yokonzedwa kale mu Function Manager, chifukwa chake muyenera kupita njira zina. Kugwiritsa ntchito kabukhu ka mafomula kumangogwira ntchito pazowerengera zovuta, mwachitsanzo, zomwe zimagwiritsa ntchito manambala ovuta. Tiyeni tiwone njira zonse zogwirira ntchito pansipa.

ndondomeko kuchotsa

Choyamba, monga tafotokozera, muyenera kulemba chizindikiro chofanana mu nthawi ya ntchito kapena mu selo lokha. Izi zikuwonetsa kuti mtengo wa selo ndi wofanana ndi zotsatira za masamu. Kupitilira apo, m'mawuwo, wochepetsedwa ayenera kuwonekera - nambala yomwe idzakhala yocheperako chifukwa cha kuwerengera. Nambala yachiwiri imachotsedwa, yoyamba imakhala yochepa nayo. Kuchotsera kumayikidwa pakati pa manambala. Simufunikanso kupanga dash kuchokera ku hyphen, apo ayi zomwe sizingagwire ntchito. Tiyeni tiwone njira zisanu zochotsera ma spreadsheets mu Excel. Wogwiritsa ntchito aliyense azitha kusankha njira yabwino pawokha pamndandandawu.

Chitsanzo 1: Kusiyana kwa Nambala Zachindunji

Gome limapangidwa, maselo amadzazidwa, koma tsopano muyenera kuchotsa chizindikiro chimodzi kuchokera ku china. Tiyeni tiyese kuchotsa nambala imodzi yodziwika kuchokera ku ina.

1. Choyamba muyenera kusankha selo lomwe zotsatira za kuwerengera zidzakhala. Ngati pali tebulo papepala, ndipo ili ndi mzere wazinthu zotere, muyenera kuyima pa imodzi mwamaselo omwe ali mugawoli. M'chitsanzo, tikambirana za kuchotsa mu selo mwachisawawa.
2. Dinani kawiri pa izo kuti gawo liwonekere mkati. M'gawoli, muyenera kuyika mawu mu mawonekedwe omwe afotokozedwa kale: chizindikiro "=", chochepetsedwa, chotsitsa ndi chochotsera. Mukhozanso kulemba mawu mu mzere wogwira ntchito, womwe uli pamwamba pa pepala. Zotsatira za zochita zonsezi zikuwoneka motere:

Tcherani khutu! Pakhoza kukhala nambala iliyonse ya subtrahends, zimatengera cholinga cha kuwerengera. Pamaso pa aliyense wa iwo, kuchotsera kumafunika, apo ayi kuwerengera sikudzachitika molondola.

3. Ngati manambala omwe ali m'mawuwo ndi zigawo zake zina zalembedwa molondola, muyenera kukanikiza batani la "Enter" pa kiyibodi. Kusiyanitsa kumawonekera nthawi yomweyo mu cell yomwe yasankhidwa, ndipo mu mzere wa ntchito mutha kuwona mawu olembedwa ndikuwunika zolakwika. Pambuyo powerengera zokha, chinsalu chikuwoneka motere:

Microsoft Excel spreadsheet idapangidwanso kuti iwerengere bwino, chifukwa chake imagwira ntchito ndi manambala abwino komanso oyipa. Sikoyenera kuti minuend ikhale nambala yokulirapo, koma zotsatira zake zidzakhala zochepa kuposa ziro.

Chitsanzo 2: kuchotsa nambala m’selo

Kugwira ntchito ndi maselo a tebulo ndiye ntchito yayikulu ya Excel, kotero mutha kuchita nawo zinthu zosiyanasiyana. Mwachitsanzo, mukhoza kulemba mawu a masamu pamene selo lachepetsedwa ndipo nambala imachotsedwa, kapena mosiyana.

1. Chochita choyamba ndikusankha selo la fomula kachiwiri ndikuyikamo chizindikiro chofanana.
2. Kenaka, muyenera kuchita mosiyana ndi njira yoyamba - muyenera kupeza selo patebulo ndi mtengo womwe udzachepa chifukwa chochotsa, ndikudina. Ndondomeko ya madontho a m'manja imapangidwa mozungulira seloli, ndipo dzina lake ngati chilembo ndi nambala zidzawonekera mu fomula.
3. Kenako, timayika chizindikiro "-", ndipo pambuyo pake timalemba pamanja subtrahend mu fomula. Muyenera kupeza mawu ngati awa:

4. Kuti muyambe kuwerengera, muyenera kukanikiza batani la "Enter". Panthawi yowerengera, pulogalamuyo idzachotsa nambala kuchokera pazomwe zili mu selo. Momwemonso, zotsatira zake zidzawonekera mu selo ndi ndondomeko. Zotsatira chitsanzo:

Chitsanzo 3: kusiyana pakati pa manambala m'maselo

Sikofunikira kuti mawuwo akhale ndi nambala imodzi - zochita zonse zitha kuchitidwa ndi ma cell okha. Izi ndizothandiza ngati pali mizati yambiri patebulo ndipo muyenera kuwerengera mwachangu zotsatira zomaliza pogwiritsa ntchito kuchotsa.

1. Kuwerengera kumayamba ndikuyika chizindikiro chofanana mu cell yosankhidwa.
2. Pambuyo pake, muyenera kupeza selo lomwe lili ndi minuend. Ndikofunika kuti tisasokoneze zigawo za tebulo wina ndi mzake, chifukwa kuchotsa kumasiyana ndi kuwonjezera mu dongosolo lokhwima lomwe mawuwo amalembedwa.
3. Pambuyo kuwonekera pa izo, ntchitoyo adzakhala ndi dzina mu mawonekedwe a mzere ndi mizere mayina, mwachitsanzo, A2, C12, ndi zina zotero. Ikani chotsitsa ndikupeza mu tebulo cell yokhala ndi subtrahend.
4. Muyeneranso kudina, ndipo mawuwo adzakhala athunthu - kutchulidwa kwa subtrahend kumangogweramo. Mutha kuwonjezera ma deductibles ndi zochita zambiri momwe mukufunira - pulogalamuyo imangowerengera zonse. Onani momwe mawu omaliza amawonekera:

5. Timakanikiza kiyi ya "Enter" ndipo timapeza kusiyana pakati pa zomwe zili m'maselo angapo popanda zochita zosafunikira monga kukopera kapena kulowetsanso manambala pamanja.

Zofunika! Lamulo lalikulu logwiritsa ntchito njirayi ndikuwonetsetsa kuti ma cell omwe ali m'mawuwo ali m'malo oyenera.

Chitsanzo 4: Kuchotsa ndime imodzi pa ina

Pali nthawi pamene muyenera kuchotsa zomwe zili m'maselo a ndime imodzi kuchokera ku maselo a wina. Si zachilendo kuti ogwiritsa ntchito ayambe kulemba mafomu osiyana pamzere uliwonse, koma iyi ndi njira yowononga nthawi. Kuti musunge nthawi yolemba mawu ambiri, mutha kuchotsa ndime imodzi kuchokera pa ina ndi ntchito imodzi.

Zifukwa zogwiritsira ntchito njirayi zingakhale zosiyana, koma chimodzi mwazofala kwambiri ndichofunika kuwerengera phindu. Kuti muchite izi, muyenera kuchotsa mtengo wa katundu wogulitsidwa kuchokera ku ndalama zomwe mumapeza. Ganizirani njira yochotsera pogwiritsa ntchito chitsanzo ichi:

1. Ndikofunikira kudina kawiri pagawo lapamwamba lagawo lopanda kanthu, lowetsani chizindikiro "="".
2. Kenako, muyenera kupanga chilinganizo: sankhani selo lomwe lili ndi ndalama, liyikeni muminus ntchito itatha kutchulidwa, ndikudina pa cell ndi mtengo wake.

Chenjerani! Ngati ma cell asankhidwa bwino, simuyenera kudina pazinthu zina za pepalalo. Ndizosavuta kuti musazindikire kuti minuend kapena subtrahend yasintha mwangozi chifukwa cha cholakwika chotere.

3. Kusiyanitsa kudzawonekera mu selo mutakanikiza batani la "Enter". Musanachite masitepe ena onse, muyenera kuwerengera.

4. Yang'anani kumunsi kumanja kwa selo losankhidwa - pali lalikulu laling'ono. Mukasuntha pamwamba pake, muvi umasanduka mtanda wakuda - ichi ndi chizindikiro chodzaza. Tsopano muyenera kugwira pansi kumanja ngodya ya selo ndi cholozera ndi kukokera pansi ku selo lotsiriza m'gulu tebulo.

Zofunika! Kusankha maselo otsika pambuyo pogogomezera ndondomeko ya selo lapamwamba m'malo ena sikudzatsogolera kusamutsidwa kwa chilinganizo ku mizere ili pansipa.

5. Njira yochotsera imasunthira ku selo iliyonse yazagawo, ndikuyika minuend ndi subtrahend ndi mzere wofananira. Izi ndi zomwe zikuwoneka:

Chitsanzo 5: Kuchotsa nambala inayake pagawo

Nthawi zina ogwiritsa ntchito amafuna kuti kusintha pang'ono kuchitike pokopera, ndiye kuti, selo limodzi lomwe likugwira ntchito silinasinthe. Izi ndizothekanso chifukwa cha Microsoft Excel spreadsheet.

1. Muyenera kuyambanso posankha selo laulere ndi zigawo za mawuwo, ndikuyika zizindikiro "=" ndi "-". Tangoganizani kuti muzochitika zinazake, subtrahend iyenera kukhala yosasinthika. Fomula imatenga mawonekedwe okhazikika:

2. Pamaso pa chidziwitso cha subtrahend cell, kalata ndi nambala, muyenera kuyika zizindikiro za dola. Izi zidzakonza subtrahend mu fomula, sizingalole kuti selo lisinthe.

3. Tiyeni tiyambe kuwerengera podina batani la "Lowani", mtengo watsopano udzawonekera pamzere woyamba wagawo.
4. Tsopano mutha kudzaza ndime yonse. Ndikofunikira kugwira cholembera kumunsi kumanja kwa selo yoyamba ndikusankha magawo otsala a gawolo.

5. Kuwerengera kudzachitidwa ndi maselo onse ofunikira, pamene subtrahend sidzasintha. Mukhoza kuyang'ana izi mwa kuwonekera pa imodzi mwa maselo osankhidwa - mawu omwe amadzazidwa nawo adzawonekera pamzere wa ntchito. Mtundu womaliza wa tebulo umawoneka motere:

Selo lochepetsedwa lingakhalenso selo lokhazikika - zimatengera komwe mungayike zizindikiro za "$". Chitsanzo chowonetsedwa ndi chapadera, chilinganizo sichiyenera kuwoneka chonchi nthawi zonse. Chiwerengero cha zigawo zofotokozera chikhoza kukhala chilichonse.

Kuchotsa manambala mu intervals

Mutha kuchotsa nambala imodzi kuchokera pazomwe zili mugawo pogwiritsa ntchito ntchito ya SUM.

1. Sankhani cell yaulere ndikutsegula "Function Manager".
2. Muyenera kupeza ntchito ya SUM ndikusankha. Zenera lidzawoneka lodzaza ntchitoyi ndi ma values.
3. Timasankha maselo onse a mzere wochepetsedwa, kumene kuli makhalidwe, nthawiyo idzagwera mu mzere "Nambala 1", mzere wotsatira suyenera kudzazidwa.

4. Pambuyo podina batani la "Chabwino", kuchuluka kwa maselo onse a ocheperako kudzawonekera pazenera la kusankha nambala mu cell, koma uku sikumapeto - muyenera kuchotsa.
5. Dinani kawiri pa selo ndi fomula ndikuyika chizindikiro chochotsera pambuyo pa bulaketi yotseka.
6. Kenako, muyenera kusankha selo kuti muchotse. Chifukwa chake, formula iyenera kuwoneka motere:

7. Tsopano mutha kukanikiza "Lowani", ndipo zotsatira zomwe mukufuna zidzawonekera mu cell.
8. Nthawi ina imatha kuchotsedwa, chifukwa chake muyenera kugwiritsa ntchito ntchito ya SUM pambuyo pa minus. Chotsatira chake, kagawo kakang'ono kamene kamachotsedwa kwa mzake. Tiyeni tiwonjezere pang'ono patebulo ndi zikhalidwe zomwe zili mugawo la subtrahend kuti zimveke bwino:

IMSUBTR ntchito

Mu , ntchitoyi imatchedwa IMNIM.DIFF. Ichi ndi chimodzi mwa ntchito zaumisiri, ndi chithandizo chake mutha kuwerengera kusiyana kwa manambala ovuta. Nambala yovuta imakhala ndi mayunitsi enieni komanso ongoyerekeza. Ngakhale pali kuphatikiza pakati pa mayunitsi, mawu awa ndi nambala imodzi, osati mawu. Kunena zoona, n’zosatheka kuganiza chonchi, ndi masamu chabe. Manambala ovuta akhoza kuyimiridwa pa ndege ngati mfundo.

Kusiyana koyerekeza ndiko kuphatikiza kwa kusiyana pakati pa magawo enieni ndi ongoyerekeza a nambala yovuta. Zotsatira zakuchotsa kunja kwa tebulo:

(10+ 2i)-(7+10i) = 3-8i

10-7 3 =

2i-10i= -8i

1. Kuti muwerenge, sankhani cell yopanda kanthu, tsegulani "Function Manager" ndikupeza ntchito IMAGINARY DIFF. Ili mu gawo la "Engineering".
2. Pawindo losankha nambala, muyenera kudzaza mizere yonse iwiri - iliyonse iyenera kukhala ndi nambala imodzi yovuta. Kuti muchite izi, dinani pamzere woyamba, ndiyeno - pa selo yoyamba yokhala ndi nambala, chitani chimodzimodzi ndi mzere wachiwiri ndi selo. Fomu yomaliza ikuwoneka motere:

3. Kenako, dinani "Enter" ndikupeza zotsatira. Palibenso subtrahend imodzi mu chilinganizo, mutha kuwerengera kusiyana kongoyerekeza kwa maselo awiri okha.

Kutsiliza

Zida za Excel zimapangitsa kuchotsa kukhala kosavuta masamu. Pulogalamuyi imakupatsani mwayi wochita zonse zosavuta ndi chizindikiro chochotsera, ndikuwerengera mozama pogwiritsa ntchito manambala ovuta. Pogwiritsa ntchito njira zomwe tafotokozazi, mutha kuchita zambiri mukamagwira ntchito ndi matebulo.