Dongosolo la "kugawanika" kuti kupambana - mfundo ndi zitsanzo za ntchito

Ogwiritsa anazolowera kugwira ntchito ndi mitunduyi mu spreadsheet ntchito "kupambana" pa "Microsoft", nthawi zina kuyesera kupeza okonzeka zopangidwa ntchito kwa kugawa nambala wani ndi mzake. Koma palibe ntchito zotere, ndipo ntchito m'matumbo ngati izo sizitero - ndi mu "kupambana" cholinga amatanthauza osiyanasiyana. Dongosolo la gulu kuti kupambana - wangokhala chizindikiro cha backslash (/).

Kodi gawani nambala imodzi ndi wina

Mu "kupambana" buku fomu mtundu maselo zasintha manambala awiri. Iwo angakuthandizeni kuthana ndi kupanga magawano chilinganizo mu kupambana. Ndiye khungu ufulu mtundu chiyambi cha chilinganizo (ofanana =) ndi kusankha selo loyamba ndi divisible. Kenako mtundu magawano chizindikiro dongosolo kupambana - backslash - ndi kusankha foni ndi divisor a.

Umene pofuna kuti selo magawano, nkhani umene 0, "kupambana" amasonyeza yoyenera kulakwa # DIV / 0.

Zofunika! Excel limakupatsani kugawana wina ndi mzake zosiyanasiyana, kuphatikizapo tsiku. Koma pamene inu muyesera kuchita kugawikana kwa maselo kuti muli mawu, udzapeza zolakwa "# MUZILEMEKEZA!" Pali mtengo cholakwika.

Kudulidwa kwa chakacho

N'zochititsa chidwi kwambiri kugawana masiku. Yesetsani "01/01/2017" kuti "01.01.2016". Iwe ukuganiza bwino? Izi si choncho. Popeza kuti "kupambana" adzakhala basi kutembenuza masiku onse angapo, kuwerengera chiwerengero cha masiku zinapita kuyambira January 1, 1900. Tsiku "01.01.1900" - nambala 1, "01/02/1900" - 2. Mutha onani ichi ndi kusintha mtundu selo ndi masiku yake ndi "Tsiku" mtundu mu mtundu "M'ndandanda". Choncho, January 1, 2017 - nambala iyi 42736, ndi kwa masiku ambiri kuchokera tsiku lomwelo ndi mwezi m'chaka cha 1900. Choncho anagawa tsiku wina ndi mzake, tingathe kupeza chifukwa yeniyeni.

M'pake kuti mukhoza kugawana osati tsiku la tsiku, koma chiwerengero cha tsiku ndi mosemphanitsa. Popeza chilinganizo cha "kugawanika" mu kupambana akadali atchule tsiku angapo. Ndipo n'zotheka ntchito njira iliyonse yomwe inu mukufuna.

Table fission "kupambana"

Kumanga tebulo "kupambana", khungu A2: A6 manambala amenewo adzagawana (3, 7, 9, 12, 15), ndi maselo B1: E1 - chiwerengero kuti adzachita Chigawo (1, 2, 3 4).

Kulenga kugawikana kwa tebulo, ndikofunika kukumbukira za maumboni mtheradi ndi wachibale mu "kupambana". Chilinganizo cha kugawikana kupambana pokonza amenewa tebulo ndi kugwiritsa ntchito maumboni losanganikirana. Kotero kuti keyala selo imene kukopera si ankatembenukira, m'pofunika kukonza mu lopeza ndime adiresi nambala, ndi wogawira - mzere chiwerengero. Choncho, kulowa selo B2 chilinganizo «= $ A2 / B $ 1" ndipo kokerani izo kupyolera chingwe? ndiyeno tebulo lonse. Table wodzazidwa ndi deta. Tsopano imani pa selo lililonse Mwachitsanzo, pa D5. chilinganizo ake ndi awa: «= $ A5 / D $ 1". Tinachita chirichonse.

Division ndi yotsala ndi

Pamene akuchita magawano, nthawi zambiri timalandira chiwerengero fractional. Wosalira amaonera manambala amenewa ali mu "kupambana" mfundo ziwiri zofunika.

Selo, zomwe zinalembedwa chifukwa, ndi kusakhulupirika ndi "General" mtundu. Mukapita ku tsamba "Home" mu "Number" gawo, n'zotheka kwa mndandanda dropdown kusankha kusintha mtundu "Other akamagwiritsa chiwerengero" ndipo anapereka mtundu wa "M'ndandanda". Mwa mtundu uwu awerenge selo nambala malo decimal. Choncho anagawa 7/3 ife amatha kuona angapo 2,333333333, ndi thandizo yolinganizika malire a malo atatu decimal, izo lidzaonekera 2.333. Kodi inu mukuvomereza, ndi yabwino ndithu.

The "kupambana" ali ntchito awiri osiyana kutenga quotient ndipo wotsalawo magawano. Iwo ali kutchedwa "Private" ndi "Kusamala" ndipo onse kutenga mfundo ziwiri kuvomerezedwa - ndi numerator ndi chimene chachititsa. Ife adzamvetsa zambiri ndi iwo.

Lowani "kupambana" manambala awiri - 7 ndi 3 (D9, ndi D10 muchipindachi mu nkhani iyi), ndipo ufulu wa iwo - wa chilinganizo:

Pamene ife tikuwona, ndi quotient ndi wofanana ndi awiri, otsala - 1. Mu selo iliyonse kanthu, kulowa njira:

= E9 & "" & E10 & "/" & D10

Apa ampersand amathandiza angagwirizanitse nkhani za nkhani khungu limodzi mu lemba lina.

The chifukwa cha dongosolo ili ndi mfundo zotsatirazi: 2 1/3 - awiri mfundo gawo limodzi.

Monga mukuonera, chilinganizo cha kugawikana kupambana si akutukwana. Chinthu chachikulu kukumbukira kuti mitunduyi ndi mawerengedwe "kupambana" amagwiritsa malamulo muyezo wa masamu.