Gawani Zopanga, # DIV / O! Zolakwitsa za Makhalidwe, ndi Kuwerengera Ma Percents
Kugawaniza nambala ziwiri zomwe mukufunikira kupanga fomu popeza palibe DIVIDE ntchito ku Excel.
Mfundo zofunikira kukumbukira za Excel mawonekedwe:
- Mafomu mu Excel nthawi zonse amayamba ndi chizindikiro chofanana ( = );
- Chizindikiro chofanana nthawi zonse chimapita mu selo komwe mukufuna yankho kuti mupite;
- Chizindikiro chogawidwa ndi patsogolo slash ( / );
- Fomuyi imatsirizidwa mwa kukanikiza fungulo lolowamo pa makiyi.
Kugwiritsira ntchito zizindikiro za magulu mu mafomu
Ngakhale kuti n'zotheka kuika manambala mwachindunji, ndibwino kuti mulowetse deta muzipangizo zamagetsi ndikugwiritsa ntchito maadiresi kapena maumboni a maselowo mu njirayi monga momwe taonera pa chithunzi pamwambapa.
Pogwiritsira ntchito mafotokozedwe a selo - monga A1 kapena C5 - osati ma data enieniwo, kenako, ngati kuli kofunikira kusintha deta , ndi chinthu chosavuta kuti mutengere deta m'maselo mmalo molembanso mndandandawo.
Kawirikawiri, zotsatira za fomuyi zidzasinthidwa pokhapokha ngati deta isintha.
Gawani Chitsanzo Chitsanzo
Monga momwe tawonera mu mzere 2 mu chithunzi pamwambapa, chitsanzo ichi chimapanga ndondomeko mu selo B2 yomwe imagawaniza deta mu selo A2 ndi deta mu A3.
Fomu yomalizidwa mu selo B2 idzakhala:
= A2 / A3
Kulowa Deta
- Lembani chiwerengero cha 20 mu selo A2 ndikusindikiza fungulo lolowamo mukibokosi;
- Lembani chiwerengero cha 10 mu selo A3 ndikusindikizira fungulo lolowamo .
Kulowa Mndandanda Pogwiritsa Ntchito Kujambula
Ngakhale n'zotheka kungolemba fomuyi
= A2 / A3
kulowa mu selo B2 ndikukhala ndi yankho lolondola lachiwonetsero chachiwiri mu selolo, ndibwino kugwiritsa ntchito kuwonetsa kuwonjezera mafotokozedwe a selo ndi ma formula kuti muchepetse kuthekera kwa zolakwika zomwe zimapangidwa polemba zolakwika za selo.
Kufotokozera kumaphatikizapo kudumpha selo yomwe ili ndi deta ndi pointer ya mouse kuti uwonjezere chiwerengero cha selo pa fomu.
Kulowa ndondomekoyi:
- Lembani chizindikiro chofanana mu selo B2 kuti muyambe njirayi.
- Dinani pa selo A2 ndi ndondomeko ya mbewa kuti muwonjezere kuti selo loyang'ana pa ndondomeko pambuyo pa chizindikiro chofanana.
- Lembani chizindikiro chogawikana - kutsogolo kwa slash - ( / ) mu selo D1 mutatha kufotokoza maselo.
- Dinani pa selo A3 ndi ndondomeko ya mbewa kuti muwonjezere kuti selo loyang'ana pa ndondomeko pambuyo pa chizindikiro chogawa;
- Lembani fungulo lolowamo lolowamo mubokosilo kuti mukwaniritse fomulo;
- Yankho lachiwiri liyenera kupezeka mu selo D1 popeza 20 ogawanika ndi 10 ali ofanana ndi 2;
- Ngakhale kuti yankho likuwoneka mu selo D1, kudumpha pa seloyo kudzawonetsa chiwongoladzanja = A2 / A3 mu kapangidwe kamene kali pamwamba pa tsamba.
Kusintha Dongosolo la Fomu
Poyesa ubwino wogwiritsira ntchito ma seloloyi, yesani chiwerengero mu selo A3 kuyambira 10 mpaka 5 ndikusindikizira Enter key pa makiyi.
Yankho mu selo B2 liyenera kusinthidwa mpaka 4 kuti liwonetse kusintha kwa deta mu selo A3.
# DIV / O! Zolakwa za Makhalidwe
Cholakwika chofala kwambiri ndi ntchito zogawikana mu Excel ndi # DIV / O! malingaliro olakwika .
Cholakwika ichi chikuwonetsedwa pamene gululi muzembedzedwe la magawano lilingana ndi zero - lomwe sililoledwa mu masamu ambiri.
Chifukwa chachikulu cha izi zikuchitika ndikuti mawonekedwe osalongosoka a selo adalowetsedweramo kapena, monga momwe tawonedwera mu mzere 3 mu chithunzi pamwambapa, ndondomekoyi idasindikizidwa ku malo ena pogwiritsira ntchito kukhuta ndi kusintha kwa malingaliro a selo mulakwika .
Terengani Zigawo Zomwe Zili ndi Mavoti Ogawa
Peresenti ndi chifaniziro chokha pakati pa manambala awiri omwe amagwiritsa ntchito ntchito yogawa.
Zowonjezera, ndizochepa kapena decimal zomwe zikuwerengedwa pogawaniza nambalayi ndi chiwerengero ndi kuchulukitsa zotsatira za 100.
Maonekedwe onse a equation adzakhala:
= (nambala / denominator) * 100
Zotsatira za ntchito yogawidwa - kapena quotient - ndi yochepa, Excel imaimira izo, mwachisawawa, monga decimal, monga momwe tawonedwera mu mzere 4, pamene chiwerengero chayikidwa kwa 10, chiwerengero cha 20, ndipo quotient ndi ofanana mpaka 0,5.
Chotsatiracho chikhoza kusinthidwa kukhala peresenti posintha machitidwe mu selo mpaka peresenti yopanga kuchokera ku zosasinthika Zomwe zimapangidwira - monga momwe zasonyezera zotsatira 50% zowonekera mu selo B5 mu chithunzi pamwambapa.
Selo limenelo liri ndi mawonekedwe omwewo monga selo B4. Kusiyana kokha ndiko kupangika pa selo.
Ndipotu, peresenti yokhala peresenti ikugwiritsidwa ntchito mu Excel, pulogalamuyi imachulukitsa mtengo wamtengo wapatali pa 100 ndipo imaphatikizapo chizindikiro.
Kupanga Mafomu Ovuta Kwambiri
Kuwonjezera mawonekedwe mu fano kuti muphatikize ntchito zina - monga kuchulukitsa kapena kuwonjezerapo - pitirizani kuwonjezera olemba masamu omwe akutsatiridwa ndi selo yomwe ili ndi deta yatsopano.
Musanayambe kusinthasintha ma masamu osiyanasiyana pamodzi, komabe ndikofunikira kumvetsetsa dongosolo la ntchito yomwe Excel ikutsatila poyesa ndondomekoyi.
Kuchita, yesani chitsanzo ichi ndi sitepe ya njira yovuta kwambiri .