Cikakken bayani game da fice: Hanyar ingantacciyar hanya

Kamar yadda ka sani, akwai nau'ikan maganganu guda biyu a cikin tebur na fifita: dangi da kuma cikakke. A cikin farkon shari'ar, tunani ya bambanta a cikin shugabanci na kwafi zuwa darajar haɓakawa, kuma a biyun, an daidaita shi kuma lokacin da aka shirya ba a canzawa ba. Amma ta tsohuwa, duk adiresoshi a cikin Findel cikakke ne. A lokaci guda, sau da yawa akwai buƙatar amfani da cikakken (gyarawa) magance. Bari mu gano abin da hanyoyin da za'a iya yi.

Aikace-aikacen cikakken bayani

Tabbataccen magance muna buƙatar, alal misali, a cikin batun lokacin da muke kwafin tsari, bangare ɗaya na wanda ya ƙunshi canji da aka nuna a lambobi da yawa, na biyu yana da ƙimar da aka nuna a cikin lambobi. Wato, wannan lambar tana taka rawar da ta dace, wanda dole ne a aiwatar da wani aiki (da yawa, rarrabuwa, rarrabuwa, rarrabuwa, rarrabuwa, rarrabuwa, rarrabuwa, rarrabuwa.

Areo Excel, akwai hanyoyi guda biyu don saita tsayayyen adireshin: ta hanyar kirkirar hanyar haɗi kuma tare da taimakon aikin FVIs. Bari mu bincika kowane ɗayan hanyoyin daki-daki.

Hanyar 1: Hadakar Muhalli

Tabbas, sanannun kuma ana amfani da hanyar da za a iya amfani da ita wajen haifar da cikakkiyar magana shine amfani da cikakken hanyar haɗi. Cikakken nassoshi suna da bambanci ba kawai aiki ba, harma da kuma Sistax. Adireshin dangi yana da irin wannan syntax:

= A1.

A adreshin adireshin kafin darajar daidaitawa ta kafa alamar dala:

= $ $ 1

Za'a iya shiga alamar Dollar da hannu. Don yin wannan, kuna buƙatar shigar da siginan kwamfuta kafin darajar farko ta tsara adireshin (a kwance) a cikin tantanin halitta ko a cikin tsari. Bayan haka, a cikin tsarin ingancin Ingilishi, danna maɓallin "4" a cikin babban yanayin (tare da maɓallin "sau ɗaya"). A nan ne alamar dala take. Sannan kuna buƙatar yin wannan hanyar tare da daidaitawar a tsaye.

Akwai hanya mai sauri. Kuna buƙatar saita siginan siginar zuwa tantanin halitta wanda a cikin adireshin ke located kuma danna kan maɓallin f4. Bayan haka, za a bayyana alamar dala nan da nan koyaushe kafin yin aiki a kwance kuma a tsaye wannan adireshin.

Yanzu bari mu bincika yadda ake amfani da cikakken adireshin da ake amfani da shi ta hanyar amfani da ingantattun hanyoyin haɗi.

Theauki tebur da albashin ma'aikata ana lissafta. Ana yin lissafin ta hanyar ninka girman albashinsu ga ƙayyadadden madaidaiciya, wanda iri ɗaya ne ga duk ma'aikata. Matsakaicin kanta kanta yana cikin sel na ganye. Muna fuskantar aikin yin lissafin albashi na duk ma'aikata da sauri.

1. Don haka, a cikin kwalin farko na shafi na WADA, mun gabatar da dabara don ninka darajar ma'aikaci mai dacewa zuwa mafi karancin aiki. A cikin lamarinmu, wannan dabara tana da irin wannan:

   = C4 * G3



2. Don yin lissafin sakamako da aka gama, danna maɓallin Shigar a kan keyboard. An nuna sakamakon a cikin tantanin halitta.



3. Mun lissafta darajar albashi na ma'aikaci na farko. Yanzu muna buƙatar yin shi don sauran layuka. Tabbas, za a iya rubuta aikin a cikin kowane sel "Hakkin shafi" da hannu, da kuma gabatar da irin wannan tsari tare da yin aiki da sauri, kuma ba mu da aiki da sauri don yin lissafi, kuma shigarwar da hannu zata dauki babban adadin lokaci. Kuma me yasa ake ci gaba da kokarin a kan shigarwar jagora, idan an kwafa dabara a wasu sel?

   Don kwafa dabara, muna amfani da irin wannan kayan aiki azaman mai alama. Mun zama sigin sigari zuwa ƙananan kusurwar dama ta tantanin halitta, inda take ƙunshe. A lokaci guda, siginan dole ne su canza cikin wannan alamar alama ta cika a cikin hanyar gicciye. Tura maɓallin linzamin kwamfuta na hagu kuma cire siginan ƙasa zuwa ƙarshen tebur.



4. Amma, kamar yadda muke gani, maimakon madaidaicin lissafin albashi ga wasu ma'aikata, mun sami wasu zeros.



5. Muna kallon abin da dalilin wannan sakamakon. Don yin wannan, muna haskaka sel na biyu a cikin shafi na albashi. Kirkirar Kirkiro yana nuna magana mai dacewa akan wannan sel. Kamar yadda kake gani, farkon factor (C5) ya yi daidai da farashin wannan ma'aikacin wanda albashin da muke tsammani. Daidaita gudun hijira idan aka kwatanta da tantanin da ya gabata saboda kaddarorin da aka danganta. Koyaya, a zahiri wannan yanayin, wannan wajibi ne a gare mu. Godiya ga wannan farkon farkon, yawan ma'aikaci da muke buƙata shi ne. Amma jujjuyawar motsi ya faru tare da mahimmancin na biyu. Kuma yanzu adireshinsa yana nufin ba shi da tsada (1.28), amma a kan sel wofi a ƙasa.

   

   Wannan shine dalilin yin lissafin albashin na ma'aikata masu zuwa daga jerin da aka juya ba daidai ba.

6. Don gyara halin da ake ciki, muna buƙatar canza adireshin na biyu tare da dangi zuwa gyarawa. Don yin wannan, mun koma zuwa farkon sel na "albashi", nuna shi. Bayan haka, muna matsawa zuwa jerin dabarun da muke buƙata ya nuna. Muna haskaka siginan siginar na biyu factor (g3) kuma danna maɓallin mai taushi a kan keyboard.



7. Kamar yadda muke gani, alamar dala bayyana kusa da daidaitawar na na biyu, da wannan, kamar yadda muke tunawa, shine sifofin cikakkiyar magana. Don nuna sakamako akan allon muna danna maɓallin Shigar.



8. Yanzu, kamar yadda ya gabata, muna kiran alamar cika da ke cike siginan siginan zuwa ƙananan kusurwar dama na kashi na farko na shafi na wayar. Tura maɓallin linzamin kwamfuta na hagu kuma cire shi.



9. Kamar yadda muke gani, a wannan yanayin lissafin da aka aiwatar daidai da kuma yawan albashi don duk ma'aikatan masana'antar an lasafta su daidai.



10. Duba yadda aka kwafa dabara. Don yin wannan, mun ware kashi na biyu na shafi na wayar. Muna duban bayyanar da ke cikin tsarin dabara. Kamar yadda muke gani, da daidaitawar farkon factor (C5), wanda har yanzu akwai dangi, motsa idan aka kwatanta da sel na baya zuwa maki daya a tsaye. Amma na biyu ya na biyu ($ G $ 3), magana a cikin wanda muka gyara bai canza ba.

Excel ma yana amfani da abin da ake kira gauraye. A wannan yanayin, ko dai a shafi ko kirtani yana rikodin a adireshin. Ana samun wannan ta hanyar da aka sanya alamar alamar dala kawai kafin ɗaya daga cikin ayyukan. Ga misalin kwatankwacin hanyar haɗin haɗi:

= $ 1

Wannan adireshin ana ɗaukar shi hade:

= $ A1

Wato, cikakkiyar magana a cikin haɗin haɗin ana amfani da shi ne kawai don ɗayan ɗayan ƙayyadaddun abubuwa biyu.

Bari mu ga yadda ake amfani da irin wannan hanyar haɗi ta hanyar aiwatarwa akan tsarin teburin albashi iri ɗaya na masana'antu.

1. Kamar yadda muke iya gani, a baya muka yi duk daidaiton na biyu masu yawa suna da cikakkiyar magana. Amma bari mu tantance shi idan dole ne a gyara dabi'un duka biyun a wannan yanayin? Kamar yadda muke gani, lokacin da kwafa, canjin tsaye ya faru, kuma daidaitawar kwance ba ya canzawa. Sabili da haka, yana yiwuwa a amfani da cikakkiyar magana kawai zuwa ga daidaitawar layin kawai na layin, kuma ya kamata a bar masu daidaitawa kamar yadda suke.

   Mun ware kashi na farko na shafi na wayar kuma a cikin tsarin tsari, muna aiwatar da magudi na sama. Mun sami dabara don wannan nau'in:

   = C4 * G $ 3

   Kamar yadda muke gani, kafaffiyar magana a cikin na biyu kiba yana amfani kawai dangane da daidaitawar zaren. Don nuna sakamakon a cikin sel danna maɓallin shigarwar.



2. Bayan haka, ta hanyar cika alamar alama, kwafa wannan tsari akan kewayon sel, wanda yake a ƙasa. Kamar yadda kake gani, ana aiwatar da lissafin albashi ga dukkan ma'aikata an yi daidai.



3. Mun kalli yadda aka cire tsari da kwafin a cikin sel na biyu na shafi wanda muka aikata mai amfani. Kamar yadda za'a iya lura da shi a cikin tsari na dabara, bayan zaɓi na wannan ɓangaren, duk da cewa cikakkiyar jawabi na biyu game da factainan na biyu yana yin jingina duka, da daidaitawar kayan aikin bai faru ba. Wannan ya faru ne saboda gaskiyar cewa mun yi kwafin kwafi ba a tsaye ba, amma a tsaye. Idan muka kwafa a kwance, to, a wannan yanayin, akasin haka, zai iya yin gyara tsarin daidaitawa, kuma don layin wannan hanya zai zama na tilas.

Darasi: cikakken da dangantakar dangantakar dangi a cikin excele

Hanyar 2: Aiki biyu

A hanya ta biyu don tsara cikakken magana a cikin tebur mai kyau shine amfani da mai aiki DVSL. Wannan fasalin yana nufin rukuni na masu aiki "haɗi da Arrays". Aikinsa shine ƙirƙirar tunani game da sel da aka ƙayyade tare da fitowar sakamakon a cikin wannan ɓangaren takardar wanda afterner kanta take. A lokaci guda, hanyar haɗin yanar gizon an haɗe zuwa ga masu aiki har ma da ƙarfi fiye da lokacin amfani da alamar dala. Sabili da haka, ana ɗauka wasu lokuta don kiran nassoshi ta amfani da Sakewa ". Wannan ma'aikaci yana da syntax mai zuwa:

= Dwarf (link_spechair; [A1])

Aikin yana da hujjoji biyu, na farkon wanda yake da matsayin m, kuma na biyu ba.

Hujja "Haɗi zuwa tantanin halitta" shine magana ne ga kayan aikin farko a cikin tsari. Wato, wannan hanyar haɗi ce ta yau da kullun, amma fursuna a cikin kwatancen. Wannan shi ne daidai da abin da zai baka damar tabbatar da kaddarorin cikakkiyar magana.

Hujja "A1" na tilas ne kuma ana amfani da shi a lokuta masu wuya. Aikace-aikacensa wajibi ne kawai lokacin da mai amfani ya zaɓi zaɓi zaɓi zaɓi, kuma ba amfani da kayan aiki na "A1" (da layukan suna da hanyar tsara ba, kuma layuka suna dijital). A madadin yana nufin yin amfani da "R1C1", a cikin wane ginshiƙai, kamar suttura, ana nuna su ta lambobi. Kuna iya canzawa zuwa wannan yanayin aiki ta hanyar taga Excel taga. Sannan, ta amfani da mai aiki DVSSL, a matsayin hujja "A1" ya kamata a ƙayyade darajar "karya". Idan kana aiki a cikin yanayin nuna nunin lokaci, kamar sauran masu amfani, to a matsayin gardama "A1" Zaka iya tantance darajar "gaskiya". Koyaya, wannan ƙimar ana nufin ta hanyar tsohuwa, da sauƙi a gabaɗaya a wannan yanayin, hujja "A1" ba takamaiman.

Bari mu kalli yadda cikakken adireshin zai yi aiki, shirya ta aikin DVRRSL, akan misalin teburin mu na albashinmu.

1. Muna samar da zaɓi na farkon shafin wayar. Mun sanya alamar "=". Kamar yadda kuka tuna, farkon abin da aka tsara a cikin ƙayyadadden lissafin da dole ne a gabatar da adireshin dangi. Sabili da haka, kawai danna tantanin halitta yana dauke da darajar daidai da albashin (C4). Bayan yadda adireshinsa ya nuna a cikin kayan don nuna sakamakon, danna maɓallin "Daidai" maɓallin (*) akan keyboard. Sannan muna buƙatar zuwa amfani da mai aiki DVSSL. Yi danna Danna akan "saka aiki" icon "icon".



2. A cikin taga aiki na Jagora na Jagora, je zuwa rukuni "Hanyoyi da Arrays". Daga cikin jerin sunayen masu suna, muna ware sunan "DVSL". Sannan danna maballin "Ok".



3. Kunna yadda ake yi muhawara na muhawara ta DVSL. Ya ƙunshi filaye biyu da suka dace da hujjojin wannan aikin.

   Mun sanya siginan kwamfuta a cikin hanyar haɗi zuwa tantanin halitta. Kawai danna wancan siginar takarda, wanda mafi ingancin yana da ƙididdige albashin (G3). Adireshin zai bayyana nan da nan a cikin taga muhawara. Idan muna ma'amala da aikin al'ada ne, to, akan wannan adireshin za'a iya la'akari dashi, amma muna amfani da aikin FVE. Kamar yadda muke tunawa, adiresoshin a cikin ya kamata da nau'in rubutu. Saboda haka, juya kewaye da tsara wannan a filin taga, kwatancen.

   Tunda muke aiki a cikin daidaitaccen daidaitattun daidaitattun daidaitawa, sannan filin "A1" BAVE. Latsa maɓallin "Ok".



4. Aikace-aikacen yana yin lissafi da kuma fitowar sakamakon sakamakon takardar yana dauke da dabara.



5. Yanzu mun sanya kwafin wannan tsari cikin duk sauran salon WAGE ɗin ta hanyar cika alamar alama, kamar yadda muka yi a da. Kamar yadda kake gani, duk sakamakon an lasafta shi.



6. Bari mu ga yadda aka nuna tsari a ɗayan sel, inda aka kwafe shi. Muna haskaka kashi na biyu na shafi kuma duba kirjin dabara. Kamar yadda kake gani, farkon farkon, wanda shine kwatankwacin dangi, ya canza daidaitawarsa. A lokaci guda, muhawara game da maganganun na biyu, wanda ake wakilta ta hanyar taki mai kyau, ba canzawa ba. A wannan yanayin, an yi amfani da wata ƙa'idar fasaha.

Darasi: Ma'aikata na Dulnsil a cikin Excele

Cikakken adireshin a cikin tebur fice za'a iya bayarwa ta hanyoyi biyu: amfani da aikin dhrsl da kuma amfani da cikakken hanyoyin haɗi. A wannan yanayin, aikin yana samar da mafi tsayayyen ɗauri ga adireshin. Hakanan za'a iya amfani da wani cikakken bayani ta amfani da gauraye da aka gauraye.