Monga "Eksele" kuwerengetsa chiwerengero: mfundo kiyi

Lero, owerenga ambiri kompyuta chidwi funso momwe "Eksele" kuwerengetsa chiwerengero. Izi ndi zoona chifukwa spreadsheets mumakhalanso deta pa chiwerengero. Pankhani kupambana, nthawi zambiri wokhudza pa kuchuluka ndi peresenti kusiyana.

chidwi 101

Ngakhale kupambana angathe kuchita zinthu zambiri, pulogalamu si kuphunzitsa inu masamu. Choncho ena kudziwa zofunika muyenera nawo. Kusonyeza chiwerengero mu mawonekedwe chidwi kupambana, muyenera kugwiritsa ntchito mwapadera kwa mtundu uwu. Ntchito, kusankha maselo kuti akumane ndi Zokongoletsa, ndiyeno dinani "PERCENTAGE" mu gulu "chiwerengero" tsamba "Home" (anaikidwa pa tepi). Kuyankhula za mmene 'Eksele "kuwerengetsa chidwi, tiona kuti mofulumira zimenezi pogwiritsa ntchito otentha kiyi kuphatikiza Ctrl + Kaonedwe +%.

Mu kupambana, ubwino m'munsi nthawi zonse kusungidwa mu mawonekedwe decimal. Choncho, ngakhale ngati ntchito mtundu wapadera kusonyeza kanthu peresenti (10%), ndi chifaniziro wophiphiritsa wa mtengo m'munsi. M'mawu ena, kupambana zonse amachita kuwerengetsera mtengo decimal (0,1). Kuti awiri onani, kusankha selo, atolankhani Ctrl + 1 ndi kuyang'ana pa zitsanzo za kuthengo mu "siyana General".

mfundo zofunika

Zokongoletsa ndi kuchuluka zingaoneke pang'ono zovuta. Choncho, pofuna kumvetsetsa za mmene kuwerengera chiwerengero mu kupambana, muyenera kuganizira mfundo zotsatirazi.

Mtundu wa makhalidwe alipo mu ntchito mtengo kuchuluka mu chipinda kuti kale deta, kupambana wachulukitsa chiwerengero mwa 100 ndipo anawonjezera% chizindikiro pa mapeto. Zimenezi zimabweretsa chisokonezo, kotero muyenera mosamala kumvetsa zimene zikuchitika.

Tiyeni tinene kuti lembani 10 A2 khungu, ndipo kenako ntchito mtundu%. Chifukwa kupambana amasonyeza chiwerengero cha multiples a 100 kusonyeza ngati kuchuluka ndi (kumbukirani kuti 1% - uyu ndi gawo limodzi mu zana), mudzaona kuti 1000% chimaonetsedwa selo, osati 10%. Ntchito padziko vutoli, mukhoza aziwerenga monga kuchuluka mu malo oyamba. Mwachitsanzo, ngati inu kulowa chilinganizo = 10/100 A2, kupambana adzakupatsani zotsatira monga 0,1 selo. Ngati mungathe ndiye mtundu deta decimal, chiwerengero adzakhala anasonyeza pamene 10% - monga mungayembekezere. Mukhozanso chabe lowetsani nambala mu mawonekedwe decimal mwachindunji mu khungu, ndiye kulowa 0,1, kenako ntchito kuchuluka mtundu. Izi kuthandiza ngati mukufuna mpata, monga "kupambana" kuwonjezera chidwi kapena kuchita zinthu zina ndi iwo.

Kanthu mtundu selo: kupambana khalidwe mosiyana pamene inu mtundu maselo chisanadze kanthu, ndipo ndiye kulowa chiwerengero. Numeri wofanana ndi wamkulu kuposa 1, ndi anatembenukira kwa chidwi ndi kusakhulupirika; manambala zosakwana 1, omwe si zoipa, ndi kuchulukitsa ndi 100 kutembenuka kuti chiwerengero. Mwachitsanzo, ngati inu lembani 10 kapena 0,1 m'chipinda reformatted, mukhoza kuona phindu la 10% anaonekera. Tsopano, ngati inu lembani 0,1, mudzaona kuti kusintha anasonyeza phindu. Komanso akhoza kukusonyezani mmene "Eksele" deduct chidwi.

Mtundu mukamalemba: Ngati inu kulowa 10% mwachindunji mu selo, kupambana adzakhala basi ntchito kuchuluka mtundu. Izi ndi zothandiza pamene mukufuna kulowa cent pa imodzi yokha pa pepala Mwachitsanzo, kuchuluka kwa msonkho kapena ntchito.

mawu chidwi

Kodi ndi pamene inu mulowa aliyense mitunduyi mu kupambana, inu ndi kuyamba kulemba mtengo, lembani chizindikiro ofanana (=) muchipindachi anasankha. Chilinganizo zina za mmene munthu "Eksele" kuwerenga chidwi tione ngati izi: = B2 / C2.

Chitsanzo china adzakhala zovuta mawerengedwe. Choncho, ngati mukufuna kuchepetsa wina kuchuluka kwa 25% pamene mumayesetsa kugwiritsa ntchito kuchotsera, chilinganizo kwanu kukhala ndi mtundu zotsatirazi: = B2 * (1-C2). Kuonjezera ndi 25%, ayenera m'malo ndi chizindikiro chochotsera mu dongosolo mu kuphatikiza.