Yadda ake ƙididdige adadin ƙididdigewa a cikin Excel

A cikin Microsoft Office Excel, yana yiwuwa a ƙididdige adadin ƙididdige ƙididdigewa ga wani samfur a cikin mafi ƙanƙancin lokaci ta amfani da dabara ta musamman. Za a gabatar da cikakkun bayanai game da lissafin a cikin wannan labarin.

Menene markup

Domin lissafin wannan siga, dole ne ku fara fahimtar menene. Markup shine bambanci tsakanin farashi da farashin kaya, wanda ke haifar da haɓakar farashin samfuran ga mabukaci na ƙarshe. Girman gefen ya dogara da dalilai da yawa, kuma ya kamata ya rufe farashi.

Kula! Margin da markup ra'ayoyi ne daban-daban guda biyu kuma bai kamata a ruɗe da juna ba. Riba shine ribar da aka samu daga siyar da kaya, wacce aka samu bayan an cire kudaden da ake bukata.

Yadda ake ƙididdige Kashi na Markup a cikin Excel

Babu buƙatar ƙidaya da hannu. Wannan bai dace ba, saboda. Excel yana ba ku damar sarrafa kansa kusan kowane aikin lissafi, yana adana lokacin mai amfani. Don ƙididdige adadin ƙididdigewa da sauri a cikin wannan software, kuna buƙatar yin matakai masu zuwa:

1. Haɗa teburin bayanan asali. Ya fi dacewa don aiki tare da ginshiƙan da aka riga aka ambata. Misali, ginshiƙin da za a nuna sakamakon dabarar ana iya kiransa "Markup,%". Koyaya, taken shafi baya shafar sakamako na ƙarshe don haka yana iya zama komai.
2. Saka alamar “Equals” daga maballin madannai cikin abin da ake buƙata, tantanin halitta mara komai na tsararrun tebur kuma shigar da tsarin da aka kayyade a sashin da ya gabata. Misali, shigar da "(C2-A2) / A2 * 100". Hoton da ke ƙasa yana nuna tsarin da aka rubuta. A cikin bakance akwai sunayen sel waɗanda a cikin su aka rubuta daidaitattun ƙimar riba da farashin kaya. A gaskiya, sel na iya bambanta.

3. Danna "Shigar" akan madannin kwamfuta don kammala tsarin.
4. Duba sakamakon. Bayan yin gyare-gyaren da ke sama, a cikin sashin tebur inda aka shigar da dabarar, yakamata a nuna takamaiman lamba wanda ke nuna alamar alamar samfur a matsayin kaso.

Muhimmin! Ana iya ƙididdige alamar alamar da hannu don bincika ko ƙimar da aka samu daidai. Idan komai yayi daidai, to dole ne a shimfiɗa tsarin da aka tsara zuwa ragowar layin tebur don cika su ta atomatik.

Yadda ake lissafin gefe a cikin MS Excel

Don cikakken fahimtar batun, ya zama dole a yi la'akari da ka'idar lissafin gefe a cikin Microsoft Office Excel. A nan ma, bai kamata a sami matsala ko da ga masu amfani da shirin ba. Don sakamako mai nasara, zaku iya amfani da algorithm mataki-mataki:

1. Ƙirƙiri maƙunsar rubutu don lissafin gefe. A cikin tsararrun tebur na farko, zaku iya sanya sigogi da yawa don lissafi, gami da gefe.
2. Sanya siginan linzamin kwamfuta a cikin madaidaicin tantanin halitta na farantin, sanya alamar "daidai" kuma rubuta dabarar da aka nuna a sama. Misali, bari mu rubuta magana mai zuwa: “(A2-C2) / C2 * 100”.

3. Danna "Shigar" daga maballin don tabbatarwa.
4. Duba sakamakon. Dole ne mai amfani ya tabbata cewa tantanin da aka zaɓa a baya yana da ƙimar da ke siffanta alamar gefe. Don tabbatarwa, zaku iya sake ƙirga ƙimar da hannu tare da ƙayyadaddun alamomi. Idan amsoshin sun haɗu, to, tsarin da aka tsara za a iya ƙarawa zuwa ragowar sel na tsararrun tebur. A wannan yanayin, mai amfani zai ceci kansa daga sake cika kowane abu da ake buƙata a cikin tebur, yana adana lokacin kansa.

Ƙarin Bayani! Idan bayan rubuta dabarar, software na Microsoft Office Excel ya haifar da kuskure, to mai amfani zai buƙaci a hankali bincika daidaiton haruffan da aka shigar a cikin magana.

Bayan ƙididdige alamomi da alamomin gefe, zaku iya ƙirƙira waɗannan ƙimar akan tebur na asali don ganin bambanci tsakanin abubuwan dogaro biyu.

Yadda ake lissafin ƙimar kashi a cikin Excel

Idan mai amfani yana buƙatar fahimtar adadin adadin jimlar adadin adadin da aka ƙididdige ya dace da shi, dole ne ya yi manipulations masu zuwa:

1. A cikin kowane tantanin halitta kyauta na takardar aikin Excel, rubuta dabarar "= ƙimar kaso * jimlar adadin." Karin bayani a hoton da ke kasa.

2. Latsa "Shigar" daga maballin PC don kammala tsarin.
3. Duba sakamakon. Maimakon dabara, takamaiman lamba za ta bayyana a cikin tantanin halitta, wanda zai zama sakamakon juyawa.

4. Kuna iya ƙaddamar da dabarar zuwa sauran layuka na tebur idan jimillar adadin daga abin da aka ƙididdige adadin ya kasance iri ɗaya ne ga yanayin gaba ɗaya.

Kula! Ana duba ƙimar ƙididdigewa cikin sauƙi da hannu ta amfani da ƙididdiga na al'ada.

Yadda ake lissafta kaso na lamba a Excel

Wannan shine tsarin baya da aka tattauna a sama. Misali, kuna buƙatar lissafin kashi nawa ne lamba 9 daga lamba 17. Don jimre wa aikin, dole ne kuyi aiki kamar haka:

1. Sanya siginan linzamin kwamfuta a cikin tantanin halitta mara komai a cikin takardar aikin Excel.
2. Rubuta dabara "= 9/17*100%".

3. Danna "Shigar" daga madannai don kammala tsarin kuma duba sakamakon ƙarshe a cikin tantanin halitta ɗaya. Sakamakon ya kamata ya zama 52,94%. Idan ya cancanta, ana iya ƙara adadin lambobi bayan maki goma.

Kammalawa

Don haka, ana ƙididdige alamar gefe don wani samfuri a cikin Microsoft Office Excel ta amfani da ma'auni. Babban abu shine rubuta magana daidai, yana nuna sel masu dacewa waɗanda aka rubuta ƙimar da ake so. Domin fahimtar wannan batu da kyau, kuna buƙatar karanta bayanan da ke sama a hankali.