Rage lambobi a cikin Excel

Daga cikin duk ayyukan lissafin, ana iya bambanta manyan guda huɗu: ƙari, ninkawa, rarrabawa da ragi. Za a tattauna na ƙarshe a wannan labarin. Bari mu ga irin hanyoyin da zaku iya aiwatar da wannan aikin a cikin Excel.

hanyar ragewa

Ragewa a cikin Excel na iya ƙunsar ƙayyadaddun lambobi da sel masu ɗauke da ƙima.

Ana iya yin aikin da kansa ta amfani da dabarar da ta fara da alamar "daidai" ("="). Sa'an nan, bisa ga dokokin lissafi, mu rubuta tsakar dare, bayan haka na sanya alama "rasa" ("-") kuma a karshen nuna karkarwa. A cikin hadaddun tsari, ana iya samun subtrahends da yawa, kuma a cikin wannan yanayin, suna biye, kuma an sanya su tsakanin su "-". Don haka, muna samun sakamakon a cikin nau'i na bambancin lambobi.

Don ƙarin haske, bari mu dubi yadda ake yin ragi ta amfani da takamaiman misalai a ƙasa.

Misali 1: Bambancin Takaitattun Lambobi

Bari mu ce muna buƙatar nemo bambanci tsakanin takamaiman lambobi: 396 da 264. Kuna iya yin ragi ta amfani da tsari mai sauƙi:

1. Mun wuce zuwa tantanin halitta kyauta na tebur wanda muke shirin yin lissafin da ake bukata. Muna buga alama a ciki "=", bayan haka muna rubuta furcin: =365-264.
2. Bayan an buga dabarar, danna maɓallin Shigar kuma muna samun sakamakon da ake bukata.

lura: Tabbas, shirin Excel na iya aiki tare da lambobi mara kyau, saboda haka, ana iya yin ragi a cikin tsari na baya. A wannan yanayin, dabarar ta kasance kamar haka: =264-365.

Misali 2: cire lamba daga tantanin halitta

Yanzu da muka rufe ka'ida da mafi sauƙin misalin ragi a cikin Excel, bari mu ga yadda ake cire takamaiman lamba daga tantanin halitta.

1. Kamar yadda yake a hanya ta farko, da farko zaɓi tantanin halitta kyauta inda muke son nuna sakamakon lissafin. A ciki:
   • muna rubuta alama "=".
   • saka adireshin tantanin halitta wanda minuend yake. Kuna iya yin haka da hannu ta shigar da haɗin kai ta amfani da maɓallan akan madannai. Ko kuma za ku iya zaɓar tantanin da ake so ta danna shi tare da maɓallin linzamin kwamfuta na hagu.
   • ƙara alamar ragi zuwa dabarar ("-").
   • rubuta subtrahend (idan akwai da yawa subtrahends, ƙara su ta alamar "-").
2. Bayan danna maɓallin Shigar, muna samun sakamakon a cikin tantanin halitta da aka zaɓa.

lura: Wannan misalin kuma yana aiki ne da jujjuyawar tsari, watau lokacin da minuend takamaiman lamba ne, kuma ƙaramar ƙima ita ce ƙimar lambobi a cikin tantanin halitta.

Misali 3: bambanci tsakanin lambobi a cikin sel

Tun da a cikin Excel mu, da farko, muna aiki tare da dabi'u a cikin sel, to, raguwa, mafi yawan lokuta, dole ne a aiwatar da tsakanin bayanan lambobi a cikinsu. Matakan sun kusan kama da waɗanda aka kwatanta a sama.

1. Mun tashi a cikin tantanin halitta, bayan haka:
   • sanya alama "=".
   • kamar misalin 2, muna nuna tantanin halitta da ke ɗauke da raguwa.
   • Hakazalika, ƙara tantanin halitta tare da ƙaramin abu a cikin dabarar, kar a manta da ƙara alama a gaban adireshinsa. "rasa".
   • idan akwai da yawa da za a cire, ƙara su a jere tare da alama "-" gaba.
2. Ta danna maɓallin Shigar, za mu ga sakamakon a cikin dabara cell.

Misali 4: Cire shafi ɗaya daga wani

Tables, kamar yadda muka sani, sun ƙunshi bayanai duka a kwance (ginshiƙai) da kuma a tsaye ( layuka). Kuma sau da yawa ana buƙatar nemo bambanci tsakanin bayanan lambobi da ke ƙunshe a cikin ginshiƙai daban-daban (biyu ko fiye). Bugu da ƙari, yana da kyawawa don sarrafa wannan tsari don kada a kashe lokaci mai yawa akan wannan aikin.

Shirin yana ba mai amfani da irin wannan dama, kuma ga yadda za a iya aiwatar da shi:

1. Je zuwa tantanin halitta na farko na ginshiƙi wanda muke shirin yin lissafi. Muna rubuta dabarar ragi, yana nuna adiresoshin sel waɗanda ke ɗauke da minuend da ƙasa. A wajenmu, maganar ta yi kama da haka: =С2-B2.
2. Latsa madannin Shigar kuma sami bambancin lambobi.
3. Ya rage kawai don aiwatar da raguwa ta atomatik ga ragowar sel na shafi tare da sakamakon. Don yin wannan, matsar da alamar linzamin kwamfuta zuwa ƙananan kusurwar dama na tantanin halitta tare da dabarar, kuma bayan alamar cika ta bayyana a cikin nau'i na alamar haɗin baki, riƙe maɓallin linzamin kwamfuta na hagu kuma ja shi zuwa ƙarshen ginshiƙi. .
4. Da zaran mun saki maɓallin linzamin kwamfuta, sel ɗin ginshiƙi za su cika da sakamakon ragi.

Misali 5: Cire takamaiman lamba daga ginshiƙi

A wasu lokuta, kuna son cire takamaiman lamba ɗaya daga duk sel a cikin ginshiƙi.

Ana iya ƙayyade wannan lambar a cikin dabara. Bari mu ce muna son cire lamba daga shafi na farko na teburin mu 65.

1. Muna rubuta dabarar ragi a cikin mafi girman tantanin halitta na ginshiƙin da aka samu. A wajenmu, yana kama da haka: =A2-65.
2. Bayan danna Shigar za a nuna bambanci a cikin tantanin halitta da aka zaɓa.
3. Yin amfani da hannun cika, muna jan dabarar zuwa wasu sel a cikin ginshiƙi don samun sakamako iri ɗaya a cikinsu.

Yanzu bari mu ɗauka cewa muna so cire takamaiman lamba daga dukkan sel na ginshiƙi, amma ba za a nuna shi kawai a cikin dabara ba, amma kuma zai kasance rubuta a cikin takamaiman tantanin halitta.

Amfanin wannan hanya babu shakka shine idan muna son canza wannan lamba, zai ishe mu mu canza shi a wuri ɗaya - a cikin tantanin halitta da ke ɗauke da ita (a cikin yanayinmu, D2).

Algorithm na ayyuka a cikin wannan yanayin shine kamar haka:

1. Je zuwa mafi girman tantanin halitta na ginshiƙi don ƙididdigewa. A cikinsa muna rubuta dabarar ragi da aka saba tsakanin sel biyu.
2. Lokacin da dabara ta shirya, kar a yi gaggawar danna maɓallin Shigar. Domin gyara adreshin tantanin halitta tare da subtrahend lokacin shimfiɗa dabarar, kuna buƙatar saka alamomi da ke gaba da haɗin gwiwar sa. "$" Ba (a wasu kalmomi, sanya adireshin tantanin halitta ya zama cikakke, tun da ta hanyar tsoho hanyoyin haɗin da ke cikin shirin dangi ne). Kuna iya yin hakan da hannu ta shigar da haruffan da suka dace a cikin dabarar, ko, lokacin gyara shi, matsar da siginan kwamfuta zuwa adireshin tantanin halitta tare da maɓalli kuma danna maɓallin sau ɗaya. F4. A sakamakon haka, dabara (a cikin yanayinmu) ya kamata ya kasance kamar haka:
3. Bayan da dabara ya shirya gaba daya, danna Shigar don samun sakamako.
4. Yin amfani da alamar cikawa, muna yin irin wannan lissafin a cikin ragowar sel na ginshiƙi.

lura: Misalin da ke sama za a iya la'akari da shi ta hanyar juyawa. Wadancan. cire daga bayanan tantanin halitta ɗaya daga wani ginshiƙi.

Kammalawa

Don haka, Excel yana ba mai amfani da nau'ikan ayyuka iri-iri, godiya ga wanda irin wannan aikin lissafin azaman ragi za a iya aiwatar da shi ta hanyoyi daban-daban, wanda, ba shakka, yana ba ku damar jure wa wani aiki na kowane rikitarwa.