Lokacin aiki tare da bayanan ƙwarewa, sau da yawa kuna buƙatar lissafa adadin adadin, ko ƙididdige yawan adadin. Microsoft Excel ne ke bayar da wannan fasalin. Amma, rashin alheri, ba kowane mai amfani zai iya amfani da kayan aikin don aiki tare da kashi ba cikin wannan aikace-aikacen. Bari mu gano yadda za a kirga adadin a Microsoft Excel.
Lissafin kashi na yawan
Da farko dai, bari mu gano yadda ake kirga adadin adadin lamba daya daga wani. Tsarin lissafin janar shine kamar haka: "= (lamba) / (total_sum) * 100%.
Don haka, don nuna ƙididdigar a aikace, mun gano yadda kashi nawa ne lamba 9 daga 17. Da farko, mun shiga cikin tantanin da za a nuna sakamakon. Tabbatar kula da tsarin da aka ayyana a cikin "Gidan" shafin a cikin Homeungiyar kayan aiki. Idan tsarin ya banbanta da kasha, to ka tabbatar saita sigar "Kashi" a fagen.
Bayan wannan, mun rubuta a cikin tantanin magana mai zuwa: "= 9/17 * 100%".
Koyaya, tunda mun saita nau'in kwayar halitta, ƙara darajar "* 100%" ba lallai bane. Isasshen iyakance ga rubuce-rubuce "= 9/17".
Don ganin sakamakon, danna maɓallin Shigar da maballin. Sakamakon haka, mun sami kashi 52.94%.
Yanzu bari muyi la’akari da yadda za’a iya kirga kashi dari ta hanyar yin aiki da bayanan tabo a cikin sel. Da ace muna buƙatar lissafin nawa kashi nawa ne na siyarwar wani nau'in samfurin daga jimlar da aka nuna a cikin sel ɗaya. Don yin wannan, a cikin layi tare da sunan samfurin, danna kan bargon mara komai, kuma saita tsararren sashi a ciki. Mun sanya alamar "=". Bayan haka, mun danna kan tantanin halitta wanda ke nuna yawan siyarwar wani nau'in samfurin. Bayan haka, sanya alamar "/". Bayan haka, mun danna kan tantanin tare da jimlar tallace-tallace na duk kaya. Don haka, a cikin tantanin halitta don fitar da sakamakon, muna da tsari.
Don ganin ƙididdigar lissafin, danna maɓallin Shigar.
Amma, ta wannan hanyar, mun gano ma'anar rabon kashi don jere ɗaya kawai. Shin da gaske ne don gabatar da lissafin makamancin wannan don kowane layi na gaba? Ba ko kaɗan ba dole. Muna buƙatar kwafin wannan dabara zuwa wasu ƙwayoyin. Amma, tunda a wannan yanayin hanyar haɗin yanar gizo tare da jimlar dole ne ta kasance ta dindindin don kada a nuna bambanci, mun sanya alamar "$" a gaban masu daidaitawa da layi da shafi. Bayan wannan, zancen tantanin daga dangi ya zama cikakke.
Na gaba, mun tsaya a cikin ƙananan kusurwar dama na tantanin halitta, ƙimar abin da an riga an ƙididdige shi, kuma, riƙe maɓallin linzamin kwamfuta, ja shi zuwa tantanin inda jimlar ta haɗa. Kamar yadda kake gani, an kwafa fom ɗin zuwa duk sauran sel na tebur. Sakamakon lissafin yana nan da nan bayyane.
Kuna iya lissafin adadin abubuwanda aka gyara daga cikin teburin, koda kuwa ba'a nuna adadin adadin ba a cikin sel ɗaya. Don yin wannan, bayan mun tsara tantanin don nuna sakamakon a hanyar samarwa, sanya alamar "=" a ciki. Bayan haka, danna kan wayar wanda rabon ku da kuke son ganowa. Mun sanya alamar "/", sannan muna fitar da adadin daga inda aka kirga ƙididdigar daga keyboard. Juya hanyar haɗin zuwa cikakke, a wannan yanayin, ba lallai ba ne.
Sannan, kamar lokacin ƙarshe, danna maɓallin ENTER, kuma ta jawo da faduwa, kwafa dabarar cikin sel ɗin da ke ƙasa.
Lissafin kashi dari
Yanzu gano yadda za a kirkiri adadin adadin a matsayin kashi na shi. Maganar gaba daya ta lissafin zata sami tsari kamar haka: "kashi_value% * total_amount". Don haka, idan muna buƙatar ƙididdige adadin 7% na 70, to muna kawai shigar da kalmar "= 7% * 70" a cikin tantanin halitta. Tunda, a ƙarshe, mun sami lamba, ba kashi ba, to a wannan yanayin ba ku buƙatar saita tsarin ƙirar. Ya kamata ya zama ɗaya ko na lamba.
Don duba sakamakon, danna maɓallin ENTER.
Wannan samfurin ya dace sosai don amfani tare da aiki tare da tebur. Misali, muna buƙatar lissafa adadin VAT, wanda a cikin Rasha shine 18%, daga farashin kowane kaya na kaya. Don yin wannan, mun tsaya a kan wani kanti a cikin layi tare da sunan samfurin. Wannan kwayar zata zama ɗayan abubuwan haɗin keɓaɓɓe, wanda zai nuna adadin VAT. Tsarin wannan kwayar a cikin tsari dari. Mun sanya alamar "=" a ciki. Mun buga lambar 18% akan maballin, kuma mun sanya alamar "*". Bayan haka, mun danna kan tantanin da aka samo adadin kudin da aka samu daga siyarwar wannan sunan samfurin. Dabarar tana shirye. A wannan yanayin, bai kamata ku canza tsarin tantanin halitta zuwa kashi ba, ko sanya hanyoyin da suka dace.
Don ganin sakamakon lissafin, danna maɓallin ENTER.
Kwafi dabarar zuwa wasu ƙwayoyin ta hanyar jawo ƙasa. Tebur tare da bayanai akan adadin VAT ya shirya.
Kamar yadda kake gani, Microsoft Excel yana ba da iko don dacewa da aiki tare da kashi dari. A wannan yanayin, mai amfani zai iya yin lissafin duka ɓangarorin adadin takamaiman a cikin kashi, da adadin adadin jimillar. Ana iya amfani da Excel don aiki tare da kashi, kamar mai lissafi na yau da kullun, amma zaka iya amfani dashi don sarrafa kansa na sarrafa lissafin kashi a cikin allunan. Wannan yana ba ku damar adana mahimmancin lokacin masu amfani da shirin a cikin lissafin.
