Yadda ake yin lissafin sha'awar Excel

Lokacin aiki tare da bayanan tabulad, yawanci ya zama dole a lissafta kashi ɗaya na lamba ko lissafin rabawa a matsayin kashi na adadin adadin. Wannan fasalin yana samar da Microsoft Excel. Amma da rashin alheri, ba kowane mai amfani ya san yadda ake amfani da kayan aiki don aiki tare da sha'awar wannan shirin ba. Bari mu gano yadda ake kirga yawan adadin a Excel.

Gaskiyar ƙimar ƙimar

Excel zai iya yin ayyuka da yawa na lissafi da yawa ciki har da mafi sauƙin lissafi na sha'awa. Mai amfani, ya danganta da bukatun, ba zai zama da wahala a ƙididdige adadin lamba da adadin adadin zaɓuɓɓuka ba, gami da zaɓukan bayanan bayanai. Don yin wannan, ya kamata ka yi amfani da wasu dabaru kawai.

Zabin 1: lissafin adadin lamba

Da farko dai, bari mu gano yadda ake lissafin adadin rabon a matsayin kashi na lamba ɗaya daga ɗayan.

1. Tsarin lissafi kamar haka: = (Lambar) / (Janar_sum) * 100%.
2. Don nuna lissafin a aikace, muna koyon nawa adadi 9 daga 17. Zaɓi tantanin da aka ƙayyade akan shafin nan "lamba" shafin. Idan tsarin ya banbanta da kashi, tabbatar da shigar da "kashi 10 na" siga a cikin filin.
3. Bayan haka, rubuta magana mai zuwa: = 9/15 * 100%.



4. Koyaya, tunda mun saita kashi ɗaya na tsarin tantanin halitta, ƙara "* 100%" don ƙarawa. Ya isa ya iyakance kanmu ga rikodin "= 9/17".



5. Don duba sakamakon, danna maɓallin Shigar. A sakamakon haka, muna samun 52,94%.

Yanzu ɗauki yadda ake yin lissafin sha'awa, aiki tare da data tabular a cikin sel.

1. A ce muna bukatar ƙidaya adadin kashi ɗaya ne na takamaiman nau'in samfurin daga jimlar da aka ƙayyade a cikin sel daban. Don yin wannan, a cikin kirtani tare da sunan kaya danna kan tantanin wood kuma saita tsarin kashi a ciki. Mun sanya alamar "=". Na gaba, danna kwayar, yana nuna darajar aiwatar da takamaiman nau'in samfurin "/". Sannan - ta hanyar kwayar halitta tare da jimlar tallace-tallace ga dukkan kaya. Don haka, a cikin tantanin halitta don fitarwa na sakamakon, mun rikodin dabara.



2. Don duba ƙimar lissafin, danna Shigar.



3. Mun gano ma'anar amfani a cikin kashi ɗaya kawai don layi ɗaya. Shin da gaske ya zama dole don gabatar da irin lissafin irin wannan layi na gaba? Ba lallai ba ne. Muna buƙatar kwafa wannan tsari zuwa wasu sel. Koyaya, tunda hanyar haɗi zuwa tantanin halitta tare da jimlar ba ta daɗe ba, to, a cikin dabara kafin daidaitawar jerin sa da shafi na $ "Mun sanya alamar" $ ". Bayan haka, tunani daga dangi ya juye.



4. Muna ɗaukar siginan siginan zuwa ƙananan kusurwar hannu ta tantanin halitta, ƙimar wanda aka riga an lasafta, kuma ta riƙe maɓallin linzamin kwamfuta, yana shimfiɗa shi zuwa tantanin halitta, inda adadin ya kasance tare. Kamar yadda kake gani, an kwafa dabara ga duk sauran sel na tebur. Nan da nan a bayyane sakamakon ƙididdiga.



5. Kuna iya ƙididdige adadin mutum na abubuwan dauyacin tebur, koda kuwa ba a nuna adadin adadin a cikin sel daban ba. Bayan tsara tantanin halitta don fitar da sakamakon a cikin adadin kashi, mun sanya alamar "=" a ciki. Na gaba, danna kan tantanin, wanda rabawa dole ya sani, sanya alamar "/" kuma sami adadin daga abin da aka lasafta kashi ɗaya. Ba kwa buƙatar kunna mahadar zuwa cikakkiyar wannan yanayin.



6. Sannan danna Shigar kuma ta hanyar jan kai tare da kwafin tsari a cikin sel, waɗanda suke ƙasa.

Zabi na 2: lissafin lambar kashi

Yanzu bari mu ga yadda ake lissafin yawan adadin kashi daga ciki.

1. Tsarin lissafi don lissafin zai sami tsari mai zuwa: ƙimar_Proccelant% * duka_sum. Sakamakon haka, idan muna buƙatar lissafta wane lamba ne, misali, 7% na 70, sannan kawai shigar da furcin "= 7% * 70" cikin sel. Tunda a ƙarshe mun sami lamba, ba kashi ba, to a wannan yanayin ba lallai ba ne a saita tsarin kashi. Dole ne ya zama na kowa ko adadi.



2. Don duba sakamakon, latsa Shigar.



3. Wannan samfurin ya dace sosai don amfani da aiki tare da tebur. Misali, muna bukatar daga samun kudaden shiga kowane sunan kayan da za su lissafa adadin vat dabi'u, wanda shine 18%. Don yin wannan, zaɓi tantanin wofi a jere tare da sunan kaya. Zai zama ɗaya daga cikin abubuwan da ke tattare da shafi na shafi wanda za'a nuna adadin VAT. Na tsara shi cikin tsari da kuma sanya alamar "=". Muna daukar lamba 18% da kuma alamar "*" a cikin keyboard. Next, danna tantanin halitta wanda aka samu wanda adadin kudaden shiga daga sayar da wannan sunan shi ne. Tsari yana shirye. Canza tsarin sel ko sanya hanyoyin da basu da alaƙa da kada ka kasance.



4. Don duba sakamakon lissafin shigarwar.



5. Kwafi da dabara a cikin sauran sel jan ja. Tebur tare da bayanai akan adadin Vat ya shirya.

Kamar yadda kake gani, shirin yana ba da damar yin amfani da shi cikin nutsuwa. Mai amfani zai iya yin lissafin kashi biyu na takamaiman adadin a cikin ɗari da lamba daga jimlar. Ana iya amfani da Eacel don aiki tare da kashi na yau da kullun, amma kuma tare da shi a sauƙaƙe aiki don lissafin sha'awa a cikin allunan.