Za'a iya amfani da aikin QUOTIENT a Excel don gudanar da aiki a kan lambobi biyu, amma zai dawo da kashi ɗaya (lambar yawan kawai) a sakamakon, ba sauran.
Babu wani "rarraba" aiki a Excel wanda zai ba ku duka lambar da adadin ƙaddara na amsa.
- Don aiwatar da ayyukan sassan yau da kullum inda aka dawo da lambar da kuma saura, yi amfani da takaddun tsari .
- Don sake dawowa kawai - raguwa ko kashi na kashi na aiki - don amfani da aikin MOD .
- Ayyukan irin wannan aikin INT ne - wanda ke yada lambobi zuwa lambobi mafi kusa - za'a iya amfani da su don cire rabon ɓangaren ƙwayar tsari.
Hanyoyin Sakamakon Ayyuka da Magana
Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara .
Maganganun aikin QUOTIENT shine:
= QUOTIENT (Mai ba da labari, Denominator)
Mai ba da labari (da ake buƙata) - rabon (lambar da aka rubuta a gaban slash ( / ) a cikin aiki na rarraba).
- Wannan hujja na iya zama ainihin lambobi ko tantancewar salula akan wurin samo bayanai a cikin takardun aiki.
Lambar lamba (da ake buƙata) - mai rarraba (lambar da aka rubuta bayan slash gaba a cikin aiki na rarraba). Wannan hujja na iya zama ainihin lambobi ko tantancewar salula akan wurin samo bayanai a cikin takardun aiki .
TAMBAYOYAN KASUWA
# DIV / 0! - Yana faruwa idan shaida ta ƙidayar daidai yake da nau'i ko ƙididdigar sel mai laushi (jere tara a misali a sama).
#VALUE! - Yana faruwa idan dai gardama ba lamba ba ne (jere takwas a misalin).
Kwalolin Ayyuka na Excel masu yawa
A cikin hoton da ke sama, misalai suna nuna hanyoyi daban-daban da za a iya amfani da aikin QUOTIENT don raba lambobi biyu idan aka kwatanta da wata takaddama.
Sakamakon daftarin tsari a cikin B4 na bane ya nuna duka biyu (2) da saura (0.4) yayin aikin QUOTIENT a cikin kwayoyin B5 da B6 ya dawo da lambar duka duk da cewa duk misalai suna rarraba lambobi guda biyu.
Amfani da Arrays a matsayin Magana
Wani zaɓi shine don amfani da tsararren don ɗaya ko fiye da muhawarar aikin kamar yadda aka nuna a jere na 7 a sama.
Tsarin da ya biyo bayan aikin yayin amfani da kayan aiki shine:
- aikin farko ya raba lambobin a cikin kowane tsararraki:
- 100/2 (amsar 50);
- 4/2 (amsar 2)
- aikin yana amfani da sakamakon mataki na farko don maganganunsa:
- Mai sharhi: 50
- Denominator: 2
Yin amfani da Excel ta QUOTIENT Function
Matakan da ke ƙasa ya rufe shigar da aikin QUOTIENT da ƙwararrakin da yake cikin tantanin halitta B6 na hoton da ke sama.
Zaɓuɓɓukan don shigar da aikin da ƙididdigar sun hada da:
- Rubuta cikakken aikin: = TAMBAYA (A1, B1) zuwa cikin cell B6 kuma
- Zabi aikin da kuma muhawara ta amfani da akwatin maganganun QUOTIENT.
Kodayake yana yiwuwa a rubuta aikin gaba ɗaya ta hannu, mutane da yawa sun fi sauƙi don amfani da akwatin maganganu don shigar da muhawarar aiki.
Lura: Idan shigar da aikin da hannu, tuna don raba dukkan muhawara tare da rikici.
Shigar da Sakamakon YAWARA
Wadannan matakai suna shigar da shigar da aikin QUOTIENT a cikin sakon B6 ta amfani da akwatin maganganun aikin.
- Danna kan B6 na jiki don sanya shi tantanin aiki - wurin da za a nuna sakamakon dabara.
- Danna kan Rubutun shafin shafin rubutun .
- Zabi Math & Trig daga ribbon don buɗe jerin aikin da aka sauke.
- Danna kan QUOTIENT a cikin jerin don kawo akwatin maganganun aikin.
- A cikin maganganun maganganu, danna kan layi na Lissafi.
- Danna kan salula A1 a cikin aikin aiki don shigar da wannan tantanin halitta a cikin akwatin maganganu.
- A cikin akwatin maganganu, danna kan layi na Denominator .
- Danna sel B1 a cikin takardun aiki.
- Danna Ya yi a cikin maganganun maganganu don kammala aikin kuma komawa cikin takardun aiki.
- Amsar 2 ya kamata ya bayyana a tantanin halitta B6, tun lokacin da kashi 12 ya raba ta 5 yana da cikakken amsar lamba 2 (tuna da ragowar da aka bari ta wurin aikin).
- Lokacin da ka danna kan tantanin B6, cikakkiyar aikin = TAMBAYOYI (A1, B1) ya bayyana a cikin maɓallin tsari a sama da takardun aiki.