Mene ne yarjejeniyar imel?

Shirin na Excel tare da taimakon kayan aiki kamar mahimmanci ya baka damar aiwatar da ayyukan kirki tsakanin bayanai a cikin sel. Irin waɗannan ayyuka sun haɗa da haɓaka. Bari mu dubi yadda za ku iya yin wannan lissafi a Excel.

Aikace-aikacen samfurin

Za a iya amfani da ƙananan Excel zuwa lambobi masu mahimmanci da kuma adireshin daga cikin sel wanda aka samo asusun. An yi wannan aikin tare da godiya ga tsari na musamman. Kamar yadda a cikin sauran lissafi na lissafi a cikin wannan shirin, kafin fasalin takaddama da ake buƙatar saita alamar daidai da (=). Sa'an nan kuma, alamar da aka ragu an ƙaddara (a matsayin nau'i ko adireshin salula). (-), na farko deductible (a cikin nau'i na lamba ko adireshin), da kuma a wasu lokuta, m deductible.

Bari mu dubi wasu misalai na yadda wannan aikin lissafi yake a cikin Excel.

Hanyar 1: Sanya Lissafi

Misali mafi sauki shi ne raguwar lambobi. A wannan yanayin, duk ayyukan da aka yi tsakanin lambobi masu mahimmanci, kamar yadda a cikin ƙirar mai ƙidayar lokaci, ba a tsakanin sel ba.

  1. Zaɓi kowane salula ko saita siginan kwamfuta a cikin tsari. Mun sanya alamar daidai. Muna buga aiki tare tare da raguwa, kamar yadda muka yi a takarda. Alal misali, rubuta irin wannan tsari:

    =895-45-69

  2. Don yin tsarin lissafi, danna kan maballin. Shigar a kan keyboard.

Bayan wadannan ayyukan an yi, ana nuna sakamakon a cikin cell da aka zaɓa. A cikin lamarinmu, wannan lambar ta 781. Idan kun yi amfani da wasu bayanai don lissafta, to, daidai ne, sakamakonku zai zama daban.

Hanyar 2: Saka Lissafi daga Siffofin

Amma, kamar yadda ka sani, Excel shine, sama da duka, shirin don aiki tare da tebur. Sabili da haka, aikin salula yana da matukar muhimmanci a ciki. Musamman ma, ana iya amfani da su don raguwa.

  1. Zaɓi tantanin halitta wanda za'a samar da maɓallin ƙaddamarwa. Mun sanya alamar "=". Danna kan tantanin halitta da ke dauke da bayanai. Kamar yadda ka gani, bayan wannan aikin, an shigar da adireshinsa a cikin sashin sharadin kuma ana karawa bayan alamar daidai. Muna buga wannan lamba wanda ya kamata a cire shi.
  2. Kamar yadda a cikin akwati na baya, don samun sakamakon sakamakon lissafi, danna maɓallin Shigar.

Hanyar 3: Saka cire Cell daga Cell

Zaka iya yin aiki na raguwa ko kuma ba tare da lambobi ba, kawai kawai ke yin amfani da adiresoshin cikin sel tare da bayanan. Hanyar ita ce daidai.

  1. Zaɓi tantanin halitta don nuna sakamakon sakamakon lissafin kuma sanya alama a cikinta daidai. Mun danna kan tantanin halitta dauke da ƙaddara. Mun sanya alamar "-". Danna kan tantanin halitta wanda ke dauke da deductible. Idan aikin yana buƙatar yin aiki tare da wasu masu karɓuwa, sa'an nan kuma mu sanya alamar "musa" kuma gudanar da ayyuka tare da wannan layi.
  2. Bayan an shigar da bayanai, don nuna sakamakon, danna maballin Shigar.

Darasi: Aiki tare da samfurori a Excel

Hanyar 4: Yin aikin sarrafawa na aiki na raguwa

Sau da yawa sau da yawa, lokacin aiki tare da Excel, yana faruwa cewa kana buƙatar lissafta ragowar wani ɓangaren kundin jikin zuwa wani shafi na sel. Tabbas, zaku iya rubuta takamammen tsari don kowane aiki tare da hannu, amma wannan zai dauki lokaci mai yawa. Abin farin ciki, aiki na aikace-aikacen zai iya yin amfani da irin wannan lissafi, don godiya ga aikin kai-tsaye.

Alal misali, muna lissafin ribar da aka samu a cikin sassa daban-daban, da sanin cikakken kudaden shiga da kuɗin samarwa. Don yin wannan, kana buƙatar ɗaukar kudin kuɗi.

  1. Zaɓi topmost cell don ribar riba. Mun sanya alamar "=". Danna kan tantanin halitta dauke da yawan kudaden shiga a cikin wannan layi. Mun sanya alamar "-". Zaɓi tantanin halitta tare da kudin.
  2. Domin nuna sakamakon sakamakon wannan layin akan allon, danna maballin Shigar.
  3. Yanzu muna buƙatar kwafin wannan maƙasudin zuwa ƙananan ƙananan don yin lissafin da ake bukata a can. Don yin wannan, sanya siginan kwamfuta a kan ƙananan gefen dama na tantanin halitta dauke da wannan tsari. Alamar cika alama ta bayyana. Danna maɓallin linzamin hagu kuma a cikin ƙasa mai ɗauka, ja mai siginan kwamfuta zuwa ƙarshen tebur.
  4. Kamar yadda kake gani, bayan waɗannan ayyukan, ana kofe wannan maƙasudin zuwa dukan layin da ke ƙasa. A daidai wannan lokacin, saboda haɗin adreshin adireshin, wannan kwafin ya faru tare da wani biya, wanda ya sa ya yiwu a lissafta sashi sosai a cikin sel.

Darasi: Yadda za a yi ba da kyauta a Excel

Hanya na 5: Rarrabaccen samfuri na bayanan kwayoyin halitta daga kewayon

Amma wasu lokuta wajibi ne a yi kawai akasin haka, wato, adireshin ba ya canza lokacin yin kwafi, amma yana ci gaba, yana nufin wani ƙirar sel. Yadda za a yi?

  1. Mu zama tantanin farko don nuna sakamakon sakamakon lissafi. Mun sanya alamar daidai. Danna kan tantanin halitta wanda aka ƙaddara shi. Saita alamar "musa". Muna danna kan tantanin salula wanda ba za'a iya canzawa ba.
  2. Kuma yanzu mun zo gagarumin bambancin wannan hanya daga baya. Wannan aikin ne wanda zai ba ka damar canza hanyar haɗi daga dangi zuwa cikakken. Saka alamar dollar a gaban haɗin keɓaɓɓe da kwance na tantanin halitta wanda adireshin bai kamata ya canza ba.
  3. Muna danna kan maɓallin kewayawa Shigarwanda ke ba ka damar nuna lissafi don wannan layin akan allon.
  4. Don yin lissafi a kan wasu layi, kamar yadda a cikin misali ta baya, muna kira mai cikawa da jawo shi.
  5. Kamar yadda kake gani, an aiwatar da raguwa kamar yadda muke bukata. Wato, a lokacin da ya sauka, adireshin da aka rage data canza, amma wanda ba a iya canjawa ba ya canzawa.

Misalin da ke sama ba kawai ƙari ne kawai ba. Hakazalika, za ka iya yin kishiyar, don haka wanda ya ɓace ya ci gaba da kasancewa mai sauƙi, kuma wanda ba shi da ɗabi'ar ya kasance dangi kuma ya canza.

Darasi: Abun cikawa da dangi suna haɗuwa a Excel

Kamar yadda zaku ga, a lura da hanyar da aka cire a cikin Excel babu wani abu mai wuya. Ana aikata bisa ga ka'idoji kamar sauran lissafin lissafi a wannan aikace-aikacen. Sanin wasu nuances masu ban sha'awa zasu ba da damar mai amfani don daidaita bayanai da yawa ta hanyar wannan aikin lissafi, wanda zai adana lokacinsa da yawa.