Ƙididdigar riba ɗaya ne daga cikin shahararrun ayyukan da ake yi a Excel. Wannan na iya zama ninka lamba da wani kaso, ƙayyade rabo (a cikin%) na takamaiman lamba, da dai sauransu. Duk da haka, ko da mai amfani ya san yadda ake yin lissafi a kan takarda, ba zai iya maimaita su kullum a cikin shirin ba. . Don haka, yanzu, za mu bincika dalla-dalla yadda ake ƙididdige sha'awa a cikin Excel.
Content
Da farko, bari mu bincika yanayin gama gari daidai lokacin da muke buƙatar tantance adadin lamba ɗaya (a matsayin kaso) a wani. Mai zuwa shine dabarar lissafi don yin wannan aikin:
Raba (%) = Lamba 1/Lambar 2*100%, ina:
- Lamba 1 - a zahiri, ƙimar mu ta asali
- Lambar 2 ita ce lamba ta ƙarshe wacce muke son gano rabon a ciki
Misali, bari mu yi ƙoƙari mu ƙididdige adadin adadin adadin 15 a lamba 37. Muna buƙatar sakamakon a matsayin kashi. A cikin wannan, ƙimar "Lambar 1" ita ce 15, kuma "Lambar 2" ita ce 37.
- Zaɓi tantanin halitta inda muke buƙatar yin lissafi. Muna rubuta alamar "daidai" ("=") sannan kuma tsarin lissafi tare da lambobi:
=15/37*100%
. - Bayan mun rubuta dabarar, sai mu danna maballin Shigar da ke kan madannai, kuma za a nuna sakamakon nan da nan a cikin tantanin halitta da aka zaba.
Ga wasu masu amfani, a cikin tantanin halitta, maimakon ƙimar kashi, ƙila za a iya nuna lamba mai sauƙi, kuma wani lokaci tare da adadi mai yawa na lambobi bayan ma'aunin ƙima.
Abun shine tsarin tantanin halitta don nuna sakamakon ba a daidaita shi ba. Mu gyara wannan:
- Muna danna-dama akan tantanin halitta tare da sakamakon (ba komai kafin mu rubuta dabarar a ciki kuma mu sami sakamako ko bayan), a cikin jerin umarnin da ya bayyana, danna kan "Format Cells..." abu.
- A cikin Tsara taga, za mu sami kanmu a cikin "Lambar" tab. Anan, a cikin nau'ikan lambobi, danna kan layin "Kashi" kuma a gefen dama na taga yana nuna adadin wuraren da ake so. Mafi yawan zaɓin shine "2", wanda muka saita a cikin misalinmu. Bayan haka, danna maɓallin Ok.
- Anyi, yanzu za mu sami ainihin ƙimar kashi a cikin tantanin halitta, wanda aka fara buƙata.
Af, lokacin da aka saita tsarin nuni a cikin tantanin halitta a matsayin kashi, ba lallai ba ne a rubuta "* 100%“. Zai isa a yi sassauƙan rabon lambobi: =15/37
.
Mu yi ƙoƙari mu yi amfani da ilimin da aka samu a aikace. Bari mu ce muna da tebur tare da tallace-tallace ta abubuwa daban-daban, kuma muna buƙatar lissafin rabon kowane samfurin a cikin jimlar kudaden shiga. Don dacewa, yana da kyau a nuna bayanan a cikin wani shafi daban. Hakanan, dole ne mu riga mun ƙididdige jimlar kudaden shiga na duk abubuwa, ta inda za mu raba tallace-tallace ga kowane samfur.
Don haka, bari mu sauka ga aikin da ke hannunmu:
- Zaɓi tantanin halitta na farko na ginshiƙi (ban da taken tebur). Kamar yadda aka saba, rubuta kowane dabara yana farawa da alamar "=“. Bayan haka, muna rubuta wata dabara don ƙididdige kashi, kama da misalin da aka yi la'akari a sama, kawai maye gurbin takamaiman ƙididdiga masu ƙima tare da adiresoshin tantanin halitta waɗanda za a iya shigar da su da hannu, ko ƙara su cikin dabara tare da danna linzamin kwamfuta. A cikin yanayinmu, a cikin tantanin halitta E2 kana bukatar ka rubuta magana mai zuwa:
=D2/D16
. lura: kar a manta da riga-ka tsara tsarin tantanin halitta na ginshiƙin da aka samu ta zaɓin nunawa azaman kashi-kashi. - Danna Shigar don samun sakamako a cikin tantanin halitta da aka bayar.
- Yanzu muna buƙatar yin irin wannan lissafin don sauran layuka na shafi. Abin farin ciki, iyawar Excel yana ba ku damar guje wa shigar da dabarar kowane tantanin halitta da hannu, kuma ana iya sarrafa wannan tsari ta hanyar kwafi (miƙewa) dabarar zuwa wasu sel. Koyaya, akwai ƙaramin nuance anan. A cikin shirin, ta tsohuwa, lokacin yin kwafin ƙididdiga, ana daidaita adiresoshin tantanin halitta bisa ga kashewa. Lokacin da ya zo ga tallace-tallace na kowane abu ɗaya, ya kamata ya kasance haka, amma daidaitawar tantanin halitta tare da jimlar kudaden shiga ya kamata ya kasance baya canzawa. Don gyara shi (sanya shi cikakke), kuna buƙatar ƙara alamar "$“. Ko, don kar a buga wannan alamar da hannu, ta hanyar nuna adreshin tantanin halitta a cikin dabarar, zaku iya danna maɓallin kawai. F4. Idan an gama, danna Shigar.
- Yanzu ya rage don shimfiɗa dabarar zuwa wasu sel. Don yin wannan, matsar da siginan kwamfuta zuwa ƙananan kusurwar dama na tantanin halitta tare da sakamakon, mai nuna alama ya kamata ya canza siffar zuwa giciye, bayan haka, shimfiɗa dabarar ƙasa ta hanyar riƙe maɓallin linzamin kwamfuta na hagu.
- Shi ke nan. Kamar yadda muke so, sel na ginshiƙi na ƙarshe sun cika da rabon tallace-tallace na kowane takamaiman samfurin a cikin jimlar kudaden shiga.
Tabbas, a cikin lissafin ba lallai ba ne don ƙididdige kudaden shiga na ƙarshe a gaba da kuma nuna sakamakon a cikin tantanin halitta daban. Ana iya ƙididdige komai nan da nan ta amfani da dabara ɗaya, wanda ga tantanin halitta E2 kamar haka: =D2/СУММ(D2:D15)
.
A wannan yanayin, nan da nan mun ƙididdige jimlar kudaden shiga a cikin tsarin lissafin rabo ta amfani da aikin SUM. Karanta game da yadda ake amfani da shi a cikin labarinmu - "".
Kamar yadda a cikin zaɓi na farko, muna buƙatar gyara adadi don tallace-tallace na ƙarshe, duk da haka, tun da tantanin halitta daban tare da ƙimar da ake so ba ya shiga cikin lissafin, muna buƙatar sanya alamun "$” kafin zayyana layuka da ginshiƙai a cikin adiresoshin tantanin halitta na jimla: =D2/СУММ($D$2:$D$15)
.
Neman kashi na lamba
Yanzu bari mu yi ƙoƙari mu ƙididdige adadin adadin a matsayin cikakkiyar ƙima, watau a matsayin lamba daban.
Tsarin lissafin lissafin shine kamar haka:
Lamba 2 = Kashi (%) * Lamba 1, ina:
- Lambar 1 ita ce lambar asali, adadin da kake son ƙididdigewa
- Kashi - bi da bi, ƙimar kashi kanta
- Lambar 2 ita ce ƙimar lamba ta ƙarshe da za a samu.
Misali, bari mu gano menene lamba 15% na 90.
- Mun zaɓi tantanin halitta wanda za mu nuna sakamakon kuma mu rubuta dabarar da ke sama, mu maye gurbin ƙimar mu a cikinsa:
=15%*90
.lura: Tunda dole ne sakamakon ya kasance cikin cikakkiyar sharuɗɗan (watau a matsayin lamba), tsarin tantanin halitta shine “gaba ɗaya” ko “lambobi” (ba “kashi” ba). - Danna maɓallin Shigar don samun sakamako a cikin tantanin halitta da aka zaɓa.
Irin wannan ilimin yana taimakawa wajen magance matsaloli masu yawa na lissafi, tattalin arziki, jiki da sauran matsaloli. Bari mu ce muna da tebur tare da tallace-tallacen takalma (a nau'i-nau'i) na 1 kwata, kuma muna shirin sayar da 10% ƙarin kwata na gaba. Wajibi ne a ƙayyade adadin nau'i-nau'i na kowane abu ya dace da waɗannan 10%.
Don kammala aikin, bi waɗannan matakan:
- Don dacewa, muna ƙirƙirar sabon shafi, a cikin sel wanda za mu nuna sakamakon lissafin. Zaɓi tantanin halitta na farko na ginshiƙi (ƙirga masu kan kai) kuma rubuta dabarar da ke sama a ciki, tare da maye gurbin takamaiman ƙimar lamba mai kama da adireshin tantanin halitta:
=10%*B2
. - Bayan haka, danna maɓallin Shigar, kuma za a nuna sakamakon nan da nan a cikin tantanin halitta tare da dabara.
- Idan muna so mu kawar da lambobi bayan ma'anar decimal, tun da yake a cikin yanayinmu za a iya ƙididdige adadin nau'i-nau'i na takalma kawai a matsayin lamba, za mu je tsarin tantanin halitta (mun tattauna yadda za a yi wannan a sama), inda muka zaɓa. sigar lamba ba tare da wurare goma ba.
- Yanzu zaku iya mika dabarar zuwa ragowar sel a cikin ginshiƙi.
A cikin lokuta inda muke buƙatar samun kashi daban-daban daga lambobi daban-daban, saboda haka, muna buƙatar ƙirƙirar ginshiƙi daban ba kawai don nuna sakamakon ba, har ma don ƙimar ƙimar.
- Bari mu ce teburinmu ya ƙunshi irin wannan ginshiƙi “E” (darajar%).
- Muna rubuta wannan dabara a cikin tantanin halitta na farko na ginshiƙin da aka samu, kawai yanzu mun canza ƙayyadaddun ƙimar kaso zuwa adireshin tantanin halitta tare da ƙimar kaso da ke cikinsa:
=E2*B2
. - Ta danna Shigar za mu sami sakamako a cikin tantanin halitta da aka bayar. Ya rage kawai don shimfiɗa shi zuwa layin ƙasa.
Kammalawa
Yayin aiki tare da tebur, sau da yawa ya zama dole don yin lissafi tare da kashi. Abin farin ciki, aikin shirin na Excel yana ba ku damar yin su da sauƙi, kuma idan muna magana game da nau'in lissafin iri ɗaya a cikin manyan tebur, tsarin zai iya zama ta atomatik, wanda zai adana lokaci mai yawa.