Yadda ake Rage Lambobi a cikin Excel - Misalai Masu Aiki 5

Ana yawan amfani da sabis ɗin maƙunsar bayanai na Microsoft Excel don tsara bayanai a sigar ƙididdiga da yin lissafi a kai. Ragewa ɗaya ne daga cikin mahimman ayyukan lissafin lissafi, babu wani hadadden lissafi ɗaya da zai iya yin sai da shi. Akwai hanyoyi da yawa don shigar da sel masu ragewa a cikin tebur, kowannensu za a tattauna dalla-dalla a ƙasa.

Yadda ake yin aikin raguwa a cikin Excel

Ragewa a cikin tebur daidai yake da akan takarda. Dole ne furcin ya ƙunshi minuend, juzu'i, da alamar "-" a tsakanin su. Kuna iya shigar da minuend da jujjuyawa da hannu ko zaɓi sel tare da wannan bayanan.

Kula! Akwai yanayi ɗaya wanda ke bambanta ragi a cikin Excel daga aiki na yau da kullun. Kowane aiki a cikin wannan shirin yana farawa da alamar daidai. Idan baku sanya wannan alamar a gaban kalmar da aka haɗa ba, sakamakon ba zai bayyana a cikin tantanin halitta ta atomatik ba. Shirin zai fahimci abin da aka rubuta a matsayin rubutu. Saboda wannan dalili, yana da mahimmanci a koyaushe sanya alamar "=" a farkon.

Wajibi ne a yi dabara tare da alamar "-", duba daidaitattun zaɓin sel ko shigar da lambobi kuma danna "Shigar". A cikin tantanin halitta inda aka rubuta dabara, bambancin lambobi biyu ko fiye zai bayyana nan da nan. Abin takaici, babu dabarar ragi a cikin Mai sarrafa Aiki, don haka dole ne ku bi wasu hanyoyi. Yin amfani da kasida na ƙididdiga zai yi aiki ne kawai don ƙarin ƙididdiga masu rikitarwa, misali, waɗanda ke amfani da lambobi masu rikitarwa. Bari mu dubi duk hanyoyin aiki a ƙasa.

hanyar ragewa

Da farko, kamar yadda aka ambata, kuna buƙatar rubuta alamar daidai a cikin kalmar ayyuka ko a cikin tantanin halitta kanta. Wannan yana nuna cewa ƙimar tantanin halitta daidai yake da sakamakon aikin lissafi. Bugu da ari, a cikin magana, raguwa ya kamata ya bayyana - lambar da za ta zama ƙasa da sakamakon lissafin. An rage lamba na biyu, na farko ya zama ƙasa da shi. Ana sanya ragi tsakanin lambobi. Ba kwa buƙatar yin dash daga saƙar, in ba haka ba aikin ba zai yi aiki ba. Bari mu bincika hanyoyi guda biyar don ragewa a cikin maƙunsar bayanai na Excel. Kowane mai amfani zai iya zaɓar hanya mai dacewa da kansa daga wannan jeri.

Misali 1: Bambancin Takaitattun Lambobi

An zana teburin, sel sun cika, amma yanzu kuna buƙatar cire alama ɗaya daga wani. Bari mu yi ƙoƙari mu cire wani sanannen lamba daga wani.

1. Da farko kuna buƙatar zaɓar tantanin halitta wanda sakamakon lissafin zai kasance. Idan akwai tebur akan takardar, kuma yana da ginshiƙi don irin waɗannan dabi'u, ya kamata ku tsaya a ɗaya daga cikin sel a wannan shafi. A cikin misali, za mu yi la'akari da raguwa a cikin tantanin halitta bazuwar.
2. Danna sau biyu don fili ya bayyana a ciki. A cikin wannan filin, kuna buƙatar shigar da magana a cikin hanyar da aka bayyana a baya: alamar "=", ragewa, alamar cirewa da raguwa. Hakanan zaka iya rubuta magana a cikin layin aiki, wanda ke sama da takardar. Sakamakon duk waɗannan ayyukan yayi kama da haka:

Kula! Ana iya samun kowane adadin subtrahends, ya dogara da manufar lissafin. Kafin kowane ɗayansu, ana buƙatar ragi, in ba haka ba ba za a aiwatar da lissafin daidai ba.

3. Idan an rubuta lambobin da ke cikin furcin da sauran sassansa daidai, ya kamata ka danna maɓallin “Shigar” da ke kan madannai. Bambanci zai bayyana nan da nan a cikin tantanin halitta da aka zaɓa, kuma a cikin layin aiki zaka iya duba rubutun da aka rubuta kuma duba shi don kurakurai. Bayan yin lissafin atomatik, allon yana kama da haka:

Hakanan an tsara maƙunsar maƙunsar Microsoft Excel don ƙididdiga masu dacewa, don haka yana aiki tare da lambobi masu kyau da mara kyau. Ba lallai ba ne cewa minuend ya zama lamba mafi girma, amma sakamakon zai zama ƙasa da sifili.

Misali 2: cire lamba daga tantanin halitta

Yin aiki tare da sel tebur shine babban aikin Excel, saboda haka zaku iya aiwatar da ayyuka iri-iri tare da su. Misali, zaku iya tsara kalmar lissafi inda aka rage tantanin halitta kuma aka cire lamba, ko akasin haka.

1. Mataki na farko shine sake zabar tantanin halitta don dabara kuma sanya alamar daidai a ciki.
2. Na gaba, kuna buƙatar yin aiki daban-daban fiye da hanyar farko - kuna buƙatar nemo tantanin halitta a cikin tebur tare da ƙimar da za ta ragu sakamakon raguwa, kuma danna kan shi. An samar da jimillar wayar hannu mai dige-dige a kewayen wannan tantanin halitta, kuma zayyananta a cikin nau'in harafi da lamba zai bayyana a cikin dabarar.
3. Bayan haka, mun sanya alamar "-", kuma bayan ta mun rubuta rubutun da hannu a cikin dabara. Ya kamata ku sami magana kamar haka:

4. Don fara lissafin, kuna buƙatar danna maɓallin "Shigar". Yayin lissafin, shirin zai cire lambar daga abubuwan da ke cikin tantanin halitta. Hakazalika, sakamakon zai bayyana a cikin tantanin halitta tare da dabara. Misalin sakamako:

Misali 3: bambanci tsakanin lambobi a cikin sel

Ba lallai ba ne cewa furcin ya ƙunshi takamaiman lamba ɗaya - duk ayyuka za a iya yin su kawai tare da sel. Wannan yana da amfani idan akwai ginshiƙai da yawa a cikin tebur kuma kuna buƙatar yin lissafin sakamakon ƙarshe da sauri ta amfani da raguwa.

1. Lissafi yana farawa da sanya alamar daidai a cikin tantanin halitta da aka zaɓa.
2. Bayan haka, kuna buƙatar nemo tantanin halitta wanda ya ƙunshi minuend. Yana da mahimmanci kada a rikitar da sassan teburin da juna, saboda ragi ya bambanta da ƙari a cikin tsari mai tsauri wanda aka rubuta magana.
3. Bayan danna shi, aikin zai sami suna a cikin nau'i na jere da zane-zane, misali, A2, C12, da sauransu. Sanya ragi kuma sami a cikin tebur tantanin halitta tare da tantanin halitta.
4. Hakanan kuna buƙatar danna kan shi, kuma magana za ta zama cikakke - ƙirar subtrahend za ta faɗo ta atomatik. Kuna iya ƙara yawan raguwa da ayyuka kamar yadda kuke so - shirin zai ƙididdige komai ta atomatik. Dubi yadda magana ta ƙarshe ta kasance:

5. Muna danna maɓallin "Shigar" kuma muna samun bambanci tsakanin abubuwan da ke cikin sel da yawa ba tare da ayyukan da ba dole ba ta hanyar kwafi ko sake shigar da lambobi da hannu.

Muhimmin! Babban ka'ida don amfani da wannan hanyar ita ce tabbatar da cewa sel a cikin magana suna cikin wuraren da suka dace.

Misali 4: Rage wani shafi daga wani

Akwai lokuta lokacin da kuke buƙatar cire abubuwan da ke cikin sel ɗaya shafi daga sel na wani. Ba sabon abu ba ne ga masu amfani su fara rubuta dabaru daban-daban na kowane jere, amma wannan tsari ne mai cin lokaci. Don adana lokacin da aka kashe wajen rubuta maganganu masu yawa, zaku iya cire shafi ɗaya daga wani tare da aiki ɗaya.

Dalilan yin amfani da wannan hanya na iya bambanta, amma ɗayan mafi yawanci shine buƙatar ƙididdige riba. Don yin wannan, kuna buƙatar rage farashin kayan da aka sayar daga adadin kuɗin shiga. Yi la'akari da hanyar ragi ta amfani da wannan misali:

1. Wajibi ne a danna sau biyu a saman tantanin halitta na ginshiƙi mara komai, shigar da alamar "=".
2. Bayan haka, kuna buƙatar zana wata dabara: zaɓi tantanin halitta tare da kudaden shiga, saka shi a cikin aikin ragewa bayan nada shi, sannan danna kan tantanin halitta tare da farashi.

Hankali! Idan an zaɓi sel daidai, kada ku danna wasu abubuwan da ke cikin takardar. Yana da sauƙi kar a lura cewa minuend ko subtrahend ya canza da gangan saboda irin wannan kuskuren.

3. Bambancin zai bayyana a cikin tantanin halitta bayan danna maɓallin "Shigar". Kafin aiwatar da sauran matakan, kuna buƙatar gudanar da lissafin.

4. Dubi ƙananan kusurwar dama na tantanin halitta da aka zaɓa - akwai ƙaramin murabba'i. Lokacin da kuka shawagi akansa, kibiya ta juya zuwa giciye baki - wannan alama ce ta cika. Yanzu kana buƙatar ka riƙe ƙasan kusurwar dama ta tantanin halitta tare da siginan kwamfuta kuma ja ƙasa zuwa tantanin halitta na ƙarshe da aka haɗa a cikin tebur.

Muhimmin! Zaɓin ƙananan ƙwayoyin sel bayan danne jigon tantanin halitta a wasu wurare ba zai haifar da canja wurin dabarar zuwa layin da ke ƙasa ba.

5. Ƙididdigar ragi za ta motsa zuwa kowane tantanin halitta na ginshiƙi, yana maye gurbin minuend da ragi tare da layin ƙira mai dacewa. Ga yadda yake kama:

Misali 5: cire takamaiman lamba daga ginshiƙi

Wani lokaci masu amfani suna son kawai wani ɗan canji ya faru lokacin yin kwafi, wato, tantanin halitta ɗaya a cikin aikin ya kasance baya canzawa. Wannan kuma yana yiwuwa godiya ga maƙunsar rubutu na Microsoft Excel.

1. Ya kamata ku sake farawa ta hanyar zabar tantanin halitta kyauta da abubuwan magana, sanya alamun "=" da "-". Ka yi tunanin cewa a cikin wani yanayi na musamman, abin da ke ƙarƙashin ƙasa dole ne ya kasance ba canzawa. Tsarin tsari yana ɗaukar daidaitaccen tsari:

2. Kafin bayanin martabar tantanin halitta, harafi da lamba, kuna buƙatar sanya alamun dala. Wannan zai gyara juzu'i a cikin dabara, ba zai ƙyale tantanin halitta ya canza ba.

3. Bari mu fara lissafin ta danna maɓallin “Shigar”, sabon ƙima zai bayyana a layin farko na ginshiƙi.
4. Yanzu za ku iya cika dukan shafi. Wajibi ne a riƙe alamar a cikin ƙananan kusurwar dama na tantanin halitta na farko kuma zaɓi sauran sassan shafi.

5. Za a gudanar da lissafin tare da duk sel masu mahimmanci, yayin da subtrahend ba zai canza ba. Kuna iya duba wannan ta danna ɗaya daga cikin sel da aka zaɓa - kalmar da aka cika da ita za ta bayyana a cikin layin aiki. Sigar ƙarshe na teburin yayi kama da haka:

Ragewar tantanin halitta kuma na iya zama tantanin halitta na dindindin - ya dogara da inda za a saka alamun “$”. Misalin da aka nuna wani lamari ne na musamman, tsarin ba koyaushe ya zama kamar haka ba. Adadin sassan magana na iya zama kowane.

Rage lambobi a cikin tazara

Kuna iya cire lamba ɗaya daga abubuwan da ke cikin shafi ta amfani da aikin SUM.

1. Zaɓi tantanin halitta kyauta kuma buɗe "Mai sarrafa ayyuka".
2. Kuna buƙatar nemo aikin SUM kuma zaɓi shi. Taga zai bayyana don cika aikin da ƙima.
3. Mun zaɓi duk sel na layin da aka rage, inda akwai dabi'u, tazara zai fada cikin layin "Lambar 1", layin na gaba baya buƙatar cikawa.

4. Bayan danna maballin "Ok", jimlar duk sel na wanda aka rage zai bayyana a cikin taga zaɓin lamba a cikin tantanin halitta, amma wannan ba shine ƙarshen ba - kuna buƙatar cirewa.
5. Danna sau biyu akan tantanin halitta tare da dabara kuma ƙara alamar cirewa bayan sashin rufewa.
6. Na gaba, kuna buƙatar zaɓar tantanin halitta don cirewa. A sakamakon haka, tsarin ya kamata ya kasance kamar haka:

7. Yanzu zaka iya danna "Enter", kuma sakamakon da ake so zai bayyana a cikin tantanin halitta.
8. Za a iya rage wani tazara, saboda wannan kuna buƙatar sake amfani da aikin SUM bayan ragi. Sakamakon haka, an cire tazara ɗaya daga ɗayan. Bari mu ɗan ƙara ƙarin tebur tare da ƙimar da ke cikin ginshiƙi na ƙasa don tsabta:

IMSUBTR aiki

A cikin , ana kiran wannan aikin IMNIM.DIFF. Wannan ɗayan ayyukan injiniya ne, tare da taimakonsa zaku iya ƙididdige bambancin lambobi masu rikitarwa. Lamba mai sarƙaƙƙiya ta ƙunshi raka'a na gaske da na hasashe. Duk da cewa akwai ƙari tsakanin raka'o'in, wannan bayanin lamba ɗaya ce, ba magana ba. A hakikanin gaskiya, ba zai yiwu a yi tunanin irin wannan al'amari ba, ilimin lissafi ne kawai. Za a iya wakilta hadadden lambobi akan jirgin a matsayin maki.

Bambancin hasashen shi ne haɗuwa da bambance-bambancen tsakanin ainihin ɓangarorin da ke tattare da ƙima. Sakamakon ragi a wajen tebur:

(10 + 2i) (7+10i) = 3-8i

10-7 3 =

2i-10i= -8i

1. Don aiwatar da lissafin, zaɓi tantanin halitta mara komai, buɗe “Mai sarrafa ayyuka” kuma nemo aikin IMAGINary DIFF. Yana cikin sashin "Engineering".
2. A cikin taga zaɓin lamba, kuna buƙatar cika layukan biyu - kowane ya ƙunshi lamba ɗaya mai rikitarwa. Don yin wannan, danna layin farko, sannan - akan tantanin halitta na farko tare da lamba, yi daidai da layi na biyu da tantanin halitta. Tsarin ƙarshe yayi kama da haka:

3. Na gaba, danna "Enter" kuma sami sakamakon. Babu wani juzu'i fiye da ɗaya a cikin dabarar, zaku iya ƙididdige bambance-bambancen tunanin sel biyu kawai.

Kammalawa

Kayan aikin Excel suna sanya raguwa aiki ne mai sauƙi na lissafi. Shirin yana ba ku damar aiwatar da ayyuka mafi sauƙi biyu tare da alamar ragi, da kuma shiga cikin ƙididdige ƙididdiga masu mahimmanci ta amfani da lambobi masu rikitarwa. Yin amfani da hanyoyin da aka bayyana a sama, za ku iya yin abubuwa da yawa yayin aiki tare da tebur.