Pangani ndondomeko YAMODZI kuti mugawane nambala mu Google Spreadsheets
Monga Excel, Google Spreadsheets ilibe ntchito DIVIDE. M'malomwake, muyenera kupanga fomu mu Google Spreadsheets kuti muchite ntchito zagawidwe. Malangizo awa amakuyendetsani kupanga mapangidwe amagawidwe, kuphatikizapo njira zosiyanasiyana zopangira machitidwe, zolakwika zomwe mungathe kuziwona, ndi momwe mungagwiritsire ntchito njira YONSE ya zotsatira.
Gawani mu Google Spreadsheets pogwiritsa ntchito Fomu
Kugawaniza nambala ziwiri zomwe mukufunikira kuti mupange fomu , popeza palibe DIVIDE ntchito mu Google Spreadsheets.
Mfundo zofunikira kukumbukira za ma fomu a Google Spreadsheet:
- Ma formula nthawi zonse amayamba ndi chizindikiro chofanana ( = ).
- Chizindikiro chofanana nthawi zonse chimalowa mu selo kumene mukufuna yankho kuti lipite.
- Wogwila ntchitoyo ndiwotchedwa slash ( / ).
- Fomuyi imatsirizidwa mwa kukanikiza fungulo lolowamo pa makiyi.
Kugwiritsira ntchito zizindikiro za magulu mu mafomu
N'zotheka kuika manambala mwachindunji - monga momwe tawonetsera m'mizera iwiri ndi itatu mu chitsanzo chapamwamba.
Zili bwino, komabe, kuti mulowetse deta mumaselo apakompyuta ndikugwiritsa ntchito maadiresi kapena maumboni a maselowo mu njirayi monga momwe akuwonetsera mzere 4 mpaka 6 mu chitsanzo.
Pogwiritsira ntchito mafotokozedwe a selo - monga A2 kapena A5 - osati deta lenileni - pamapeto pake, ngati pakufunika kusintha deta , ndi chinthu chophweka chotsitsa deta m'maselo mmalo molembanso njirayo.
Kawirikawiri, zotsatira za fomuyi zidzasinthidwa pokhapokha ngati deta isintha.
Gawani Zitsanzo za Machitidwe
Njirayi mu selo B4 lachitsanzo:
= A2 / A3
Kungosintha deta mu selo A2 ndi deta mu A3 kuti mubweretse yankho la awiri.
Kulowa Mndandanda Ndi Point ndi Dinani
Ngakhale n'zotheka kungolemba fomuyi
= A2 / A3
Mu selo B4 ndikukhala ndi yankho lolondola lachiwonetsero 2 mu selolo, ndibwino kugwiritsa ntchito mfundo-ndi-kanilo kapena kutsogolera kuwonjezera mafotokozedwe a maselo kwa ma formula - makamaka ndi maulendo aatali.
Kuchita zimenezo kumachepetsanso kuthekera kwa zolakwika zomwe zimapangidwa polemba zolakwika za selo.
Mfundo ndi kodinkhani ikuphatikiza pa selo yomwe ili ndi deta ndi pointer ya mouse kuti uwonjeze mawonekedwe a selo pa fomu.
Kuti alowe muyeso
- Mtundu = (chizindikiro chofanana) mu selo B4 kuti ayambe kukonzekera.
- Dinani pa selo A2 ndi ndondomeko ya mbewa kuti muwonjezere kuti selo loyang'ana pa ndondomeko pambuyo pa chizindikiro chofanana.
- Mtundu / (chizindikiro cha magawo kapena slash patsogolo) mu selo B4 pambuyo powerenga selo.
- Dinani pa selo A3 ndi ndondomeko ya mbewa kuti muwonjezere kuti selo loyang'ana pa ndondomeko pambuyo pa chizindikiro chogawa.
- Lembani fungulo lolowamo lolowera mubokosilo kuti mukwaniritse chithunzicho.
- Yankho lachiwiri liyenera kupezeka mu selo B4 kuyambira 20 logawidwa ndi 10 liri lofanana ndi 2.
- Ngakhale kuti yankho likuwoneka mu selo B4, kudumpha pa seloyo kudzawonetsa chiwongoladzanja = A2 / A3 muzenera yapamwamba 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 lake 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 zogawidwa 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 ndi Mapulani a Zigawo
Peresenti ndi chifaniziro chokha pakati pa nambala ziwiri zomwe zimagwiritsa 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 - ili yosachepera imodzi, Google Spreadsheets imayimira izo, mwachindunji, monga decimal, monga momwe tawonedwera mzere wachisanu, pamene:
- Chiwerengero chayikidwa ku 10.
- Chipembedzochi chifika 20.
- The quotient ndi ofanana ndi 0.5.
Chotsatiracho chikhoza kusinthidwa kufika peresenti posintha machitidwe mu selo mpaka peresenti yopanga kuchokera kusasinthika Zomwe zimapangidwira - monga momwe zasonyezera zotsatira 50% zowonekera mu selo B6 lachitsanzo.
Selo limenelo liri ndi mawonekedwe omwewo monga selo B4. Kusiyana kokha ndiko kupangika pa selo.
Ndipotu, peresenti yokhala peresenti ikugwiritsidwa ntchito, pulogalamuyi imachulukitsa mtengo wamtengo wapatali pa 100 ndipo imawonjezera chizindikiro cha peresenti.