Division shi ne daya daga cikin ayyuka hudu na yau da kullum. Ba da daɗewa akwai lissafin ƙwayar da zai iya yi ba tare da shi ba. Excel yana da ayyuka masu yawa don yin amfani da wannan aikin lissafi. Bari mu ga yadda za mu iya yin rabuwa a Excel.
Yin raga
A cikin Microsoft Excel, za a iya yin rarraba ta hanyar amfani da takaddun ko amfani da ayyuka. Rashin rarrabe da rarraba shine lambobi da adiresoshin sel.
Hanyar 1: rarraba lamba ta lamba
Ana iya amfani da takardar Excel a matsayin nau'i mai maƙirai, kawai rarraba lambar ɗaya ta wani. Alamar rarraba slash (layin baya) - "/".
- Muna zama a cikin kowane sakon kyauta na takarda ko a layi na dabara. Mun sanya alamar daidai (=). Muna buga lambar haɗin daga keyboard. Mun sanya alamar rarraba (/). Muna buga mai rarraba daga keyboard. A wasu lokuta, akwai rabi fiye da ɗaya. Sa'an nan, sanya slash kafin kowane mai rarrabawa. (/).
- Domin yin lissafi kuma nuna sakamakonsa a kan saka idanu, danna maballin. Shigar.
Bayan haka, Excel zai lissafta ma'anar da nuna sakamakon sakamakon lissafi a cikin ƙayyadaddun tantanin halitta.
Idan aka kirkiro lissafi tare da wasu haruffa, to, tsarin da kisa ya yi ta hanyar shirin ne bisa ka'idojin lissafi. Wato, na farko, rarraba da ƙaddamarwa ana yin, kuma sai kawai sannan kuma haɓaka.
Kamar yadda ka sani, raba ta 0 shine aiki mara daidai. Saboda haka, a irin wannan ƙoƙarin yin lissafi irin wannan a Excel, sakamakon zai bayyana a tantanin halitta "#DEL / 0!".
Darasi: Aiki tare da samfurori a Excel
Hanyar 2: ragowar ƙunshiyar ciki
Har ila yau a cikin Excel, zaka iya raba bayanai a cikin kwayoyin.
- Zaɓi tantanin halitta wanda za'a nuna sakamakon lissafi. Mun sanya a cikin alamarta "=". Kusa, danna kan wurin da aka raba rarraba. Bayan wannan, adireshinsa ya bayyana a cikin tsari ta hanyar bar bayan alamar daidai. Na gaba, daga keyboard saita alamar "/". Mun danna kan tantanin salula da aka sanya mai rarraba. Idan akwai rabawa masu yawa, da kuma a cikin hanyar da ta gabata, muna nuna su duka, kuma mu sanya alamar raba a gaban adireshin su.
- Domin yin aikin (rarraba), danna maballin "Shigar".
Hakanan zaka iya haɗawa, a matsayin divisible ko rarraba, ta yin amfani da adiresoshin salula da lambobi masu mahimmanci a lokaci guda.
Hanyar 3: rarraba shafi ta shafi
Don ƙididdiga a cikin tebur, yana da yawa wajibi ne don rarraba dabi'u na ɗaya shafi a cikin bayanai na shafi na biyu. Hakika, zaku iya raba tamanin kowane tantanin halitta kamar yadda aka bayyana a sama, amma zaka iya yin wannan hanya da sauri.
- Zaɓi sel na farko a cikin shafi inda aka nuna sakamakon. Mun sanya alamar "=". Danna kan tantanin salula. Alamar bugawa "/". Danna maɓallin tantanin halitta.
- Muna danna maɓallin Shigardon lissafta sakamakon.
- Saboda haka, ana lissafta sakamakon, amma kawai don layin guda. Domin yin lissafi a wasu layuka, kana buƙatar yin matakan da ke sama don kowane ɗayan su. Amma zaka iya ajiye lokaci ta musamman ta hanyar yin magudi kawai. Saita siginan kwamfuta a saman kusurwar dama na tantanin halitta tare da tsari. Kamar yadda kake gani, gunkin ya bayyana a cikin hanyar giciye. An kira shi alamar cika. Riƙe maɓallin linzamin hagu kuma jawo makaman cikawa zuwa ƙarshen tebur.
Kamar yadda kake gani, bayan wannan aikin, za'a yi aiki na rarraba ɗayan ta na biyu, kuma za a nuna sakamakon a cikin wani shafi. Gaskiyar ita ce, ana kwashe ma'anar zuwa ƙananan ƙwayoyin ta amfani da alamar cika. Amma, la'akari da cewa ta hanyar tsoho dukkan alaƙa sun kasance dangi, ba cikakke ba, a cikin wannan tsari, yayin da kake motsawa, tantanin halitta yana canza canji dangane da haɓakar asali. Wato, wannan shine abin da muke buƙata don wani akwati.
Darasi: Yadda za a yi ba da kyauta a Excel
Hanyar 4: rarraba shafi ta akai
Akwai lokuta idan ya wajaba don rarraba shafi a cikin ɗaya kuma daidai yawan lambobi - akai, kuma ya fitar da jimlar fasalin a cikin wani shafi na dabam.
- Mun sanya alamar daidai a cikin farkon cell na karshe shafi. Danna kan tantanin halitta wanda ba za'a iya raba shi ba. Mun sanya alamar rarraba. Sa'an nan kuma hannu tare da keyboard sanya ƙasa lambar da ake so.
- Danna maballin Shigar. Sakamakon lissafi na jere na farko an nuna shi a kan saka idanu.
- Don yin lissafin dabi'u ga wasu layuka, kamar yadda a cikin lokacin da muka gabata, muna kira alamar cikawa. Kamar yadda muka cire shi.
Kamar yadda kake gani, wannan lokaci ana gudanar da raga daidai. A wannan yanayin, yayin da aka kwace bayanan tare da alamar cika, alamun sun sake zama dangi. Adireshin rarraba ga kowane layi an canza ta atomatik. Amma mai rarrabawa yana cikin wannan yanayin lambobi mai mahimmanci, wanda ke nufin cewa haɗin zumunci ba ya shafi shi. Ta haka ne, mun rarraba abubuwan da ke cikin sel na shafi a cikin akai.
Hanyar 5: rarraba shafi a cikin tantanin halitta
Amma abin da za ka yi idan kana buƙatar raba shafi a cikin abin da ke cikin sel ɗaya. Bayan haka, bisa ka'idar zumunci na nassoshi, daidaitattun rabuwa da rabawa zai canza. Muna buƙatar yin adreshin tantanin halitta tare da rabuwa.
- Saita siginan kwamfuta a cikin ɗigon ɗigon manya don nuna sakamakon. Mun sanya alamar "=". Danna kan wurin wurin rabon da aka ƙayyade darajar m. Mun sanya slash (/). Mun danna kan tantanin salula da aka sanya ma'auni mai tsada.
- Domin yin la'akari da cikakkiyar rarraba, wato, m, mun sanya alamar dollar ($) a cikin maƙirar a gaban daidaitawar kwayar halitta a tsaye da kuma a tsaye. Yanzu wannan adireshin zai kasance ba canzawa lokacin yin kwashe tare da alamar cikawa.
- Muna danna maɓallin Shigar, don nuna sakamakon sakamakon lissafi a kan layin farko akan allon.
- Amfani da alamar cika, kwafa da maƙalar zuwa sauran sassan kundin tare da sakamakon ƙarshe.
Bayan haka, an shirya sakamakon duka shafi. Kamar yadda kake gani, a wannan yanayin akwai rabuwa na shafi a cikin tantanin halitta tare da adireshin da aka gyara.
Darasi: Abun cikawa da dangi suna haɗuwa a Excel
Hanyar 6: aikin PRIVATE
Za a iya yin rarraba Excel ta amfani da aikin musamman da ake kira PRIVATE. Mahimmancin wannan aikin shine ya raba, amma ba tare da saura ba. Wato, lokacin amfani da wannan hanyar rarraba, sakamakon zai zama lamba. Bugu da ƙari, zangon ba'a yi bisa ga ka'idodin ilmin lissafi da aka yarda da ita ba ga lamba mafi kusa, amma zuwa ƙarami. Watau, lambar 5.8 ba ta zagaye har zuwa 6, amma zuwa 5.
Bari mu ga aikace-aikacen wannan aikin ta misali.
- Danna kan tantanin halitta inda za'a nuna sakamakon lissafi. Muna danna maɓallin "Saka aiki" zuwa hagu na dabarun tsari.
- Yana buɗe Wizard aikin. A cikin jerin ayyukan da yake ba mu, bincika abu "BABI NA". Zaɓi shi kuma danna maballin. "Ok".
- Ƙungiyar shawara ta buɗewa ta buɗe. PRIVATE. Wannan aikin yana da muhawara guda biyu: adadi da ƙididdiga. Sun shiga cikin filin tare da sunayen da ya dace. A cikin filin Mai ba da labari shigar da rara. A cikin filin Denominator - mai rarraba. Zaka iya shigar da lambobi da adiresoshin lambobi guda biyu da adiresoshin sassan da aka samo asusun. Bayan duk abubuwan kirki sun shiga, danna kan maballin "Ok".
Bayan waɗannan ayyukan, aikin PRIVATE aiwatar da bayanai da kuma samfurori amsar zuwa tantanin halitta da aka ƙayyade a farkon mataki na wannan hanya na rarraba.
Wannan aikin za a iya shigar da hannu ba tare da amfani da maye ba. Sakamakonsa kamar haka:
= PRIVATE (Lambar lamba)
Darasi: Wizard Function Wizard
Kamar yadda kake gani, babban hanyar hanyar rarraba a cikin shirin Microsoft Office shine amfani da samfurori. Alamar rarraba a cikinsu ita ce slash - "/". A lokaci guda, don wasu dalilai, ana iya amfani da aikin a yayin rarraba PRIVATE. Amma, wajibi ne a la'akari da cewa lokacin da aka kirga ta wannan hanyar, ana samun bambanci ba tare da saura ba, a matsayin mahadi. Bugu da ƙari, zangon da aka yi ba bisa ga al'ada da aka yarda da su ba, amma ga karami mai lamba a cikakkiyar darajar.
