Momwe Mungagawire Pakati pa Ntchito YOTSATIRA

Cholinga cha QUOTIENT mu Excel chingagwiritsidwe ntchito pochita ntchito yogawanika pa ziwerengero ziwiri, koma zidzangobweretsanso chiwerengero cha integer (nambala yokha) monga zotsatira, osati zotsalira.

Palibe "magawano" ntchito mu Excel yomwe idzakupatsani inu nambala yonse ndi magawo akumaliza a yankho.

• Kuchita ntchito zogawidwa nthawi zonse pamene chiwerengero chonse ndi zotsalira zikubwezedwa, gwiritsani ntchito ndondomeko yogawanika .
• Kubwezeretsa zokhazokha - ntchito yochepa kapena yapadera ya magawano - gwiritsani ntchito ntchito ya MOD .
• Ntchito yofanana ndi ntchito ya INT - yomwe nthawi zonse imakhala yowerengera mpaka nambala yonse yapafupi - ingagwiritsidwe ntchito kuchotsa gawo la magawo a magawo ogawikana.

Syntax ndi Zokambirana za Funso la QUOTIENT

Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa .

Chidule cha QUOTIENT ntchito ndi:

= QUOTIENT (Numerator, Denominator)

Chiwerengero (chofunika) - gawoli (chiwerengero cholembedwa patsogolo pa slash forward ( / ) mu ntchito yogawikana).

• Mtsutso uwu ukhoza kukhala nambala weniweni kapena selo loyang'ana pa malo a deta mu tsamba lolemba.

Chiwonetsero (chofunikira) - wotsogolera (chiwerengero cholembedwa pambuyo pa kuperekera patsogolo pa ntchito yopatukana). Mtsutso uwu ukhoza kukhala nambala weniweni kapena selo loyang'ana pa malo a deta mu tsamba lolemba.

QUOTIENT Zolakwitsa za Ntchito

# DIV / 0! - Zikuchitika ngati kukangana kwachipembedzo kuli kofanana ndi zero kapena malingaliro opanda chilolezo (mzere wachisanu ndi chinayi mu chitsanzo chapamwamba).

#VALUE! - Zikuchitika ngati kukangana kulibe nambala (mzere wachisanu ndi chitatu mu chitsanzo).

Excel QUOTIENT Ntchito Zitsanzo

Mu chithunzi pamwambapa, zitsanzo zikuwonetsera njira zingapo zomwe QUOTIENT ntchito ingagwiritsire ntchito kugawa manambala awiri poyerekeza ndi ndondomeko yogawa.

Zotsatira za kapangidwe kagawidwe mu selo B4 zikuwonetsa quotient (2) ndi otsala (0.4) pamene QUOTIENT ikugwira ntchito mu maselo B5 ndi B6 kubwereranso chiwerengero chonse ngakhale zitsanzo zonsezi zikugawa ziwerengero ziwiri zomwezo.

Kugwiritsira ntchito zida monga zifukwa

Njira ina ndi kugwiritsira ntchito ndondomeko imodzi kapena zingapo zomwe zimagwira ntchito monga momwe tawonedwera mzere 7 pamwambapa.

Lamulo lotsatiridwa ndi ntchito pamene mukugwiritsa ntchito zilembo ndi:

1. ntchito yoyamba imagawaniza nambala iliyonse:
   • 100/2 (yankho la 50);
   • 4/2 (yankho la 2)
2. ntchitoyo imagwiritsa ntchito zotsatira za sitepe yoyamba pazitsutsano zake:
   • Nambala: 50
   • Chipembedzo: 2
   pa ntchito yogawanitsa: 50/2 kuti athe kupeza yankho lomalizira la 25.

Kugwiritsa ntchito QUOTIENT Function ya Excel

Masitepe omwe ali m'munsimu akulowa mu QUOTIENT ntchito ndi mfundo zake zomwe zili mu selo B6 la chithunzi pamwambapa.

Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:

• Kujambula ntchito yonse: = QUOTIENT (A1, B1) mu selo B6 ndi
• Kusankha ntchito ndi zifukwa zake pogwiritsa ntchito QUOTIENT ntchito dialog box .

Ngakhale kuti n'zotheka kungolemba ntchito yonseyo ndi dzanja, anthu ambiri amavutika kuti agwiritse ntchito bokosilo kuti ayambe kukambirana.

Zindikirani: Ngati mutalowa ntchitoyi pamanja, kumbukirani kulekanitsa zokambirana ndi makasitomala.

Kulowa ntchito QUOTIENT

Zolemba izi zikulowa mu QUOTIENT ntchito mu selo B6 pogwiritsa ntchito bokosi la dialog.

1. Dinani pa selo B6 kuti mupange selo yogwira ntchito - malo omwe zotsatira zake zidzasonyezedwe.
2. Dinani pa Fomu tab ya riboni .
3. Sankhani Math & Trig kuchokera ku riboni kuti mutsegule ntchito yolemba pansi.
4. Dinani pa QUOTIENT m'ndandanda kuti mubweretse bokosi lazokambirana.
5. Mu bokosi la bokosi, dinani pa Numerator mzere.
6. Dinani pa selo A1 patsiku la ntchito kuti mulowetse selo ili mu bokosi la dialog.
7. Mu bokosi la bokosi, dinani pa mzere wa chipembedzo .
8. Dinani pa selo B1 mu tsamba la ntchito.
9. Dinani Kulungani mu bokosi kuti mukwaniritse ntchitoyo ndi kubwerera kuntchito.
10. Yankho lachiwiri liyenera kuoneka mu selo B6, popeza 12 ogawanika ndi 5 ali ndi yankho lonse lachiwiri (kumbukirani zotsalirazo zitayidwa ndi ntchito).
11. Mukachoka pa selo B6, ntchito yonse = QUOTIENT (A1, B1) ikuwoneka mu barra ya fomu pamwamba pa tsamba.