Indlela yokuhlukanisa ku-Excel Nge-QUOTIENT Umsebenzi

Umsebenzi we-QUOTIENT ku-Excel ungasetshenziswa ukwenza umsebenzi wokuhlukanisa ngezinombolo ezimbili, kodwa uzobuyisela kuphela inamba ye-integer (inani eliphelele kuphela) njengomphumela, hhayi okusele.

Ayikho umsebenzi "wokuhlukanisa" ku-Excel oyokunika kokubili inombolo ephelele nenxenye yesimanga sempendulo.

• Ukwenza imisebenzi yokuhlukaniswa njalo lapho inombolo yonke nesele ibuyiselwa khona, sebenzisa ifomula yokuhlukanisa .
• Ukuze ubuyele kuphela okusele - ingxenye engxenyeni ye-fractional noma yedesimali ye-division - sebenzisa umsebenzi we-MOD .
• Umsebenzi ofanayo umsebenzi we-INT - ohlala ujikeleza izinombolo kuze kube yilapho inamba yonke eseduzane - ingasetshenziswa ukususa ingxenye engxenyeni yefomu lesigaba.

I-Syntax ne-Arguments ye-QUOTIENT Function

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, ukwahlukanisa kwama-comma, nokuphikisana .

I-syntax yomsebenzi we-QUOTIENT yile:

= QUOTIENT (Numerator, Denominator)

Ukubala (okudingekayo) - i- dividend (inombolo ebhaliwe ngaphambi kokushaywa phambili ( / ) ekusebenzeni kokuhlukaniswa).

• Le mpikiswano ingaba inombolo yangempela noma ireferensi yeseli endaweni yedatha kufasitelana lokusebenzela.

I-denominator (edingekayo) - i- divisor (inombolo ebhaliwe ngemuva kokushaywa phambili emsebenzini wokuhlukanisa). Le mpikiswano ingaba inombolo yangempela noma ireferensi yeseli endaweni yedatha kufasitelana lokusebenzela .

I-QUOTIENT Amaphutha Okusebenza

# DIV / 0! - Ivela uma ingxabano ye-denominator ilingana ne-zero noma ibonisa iseli elingenalutho (umugqa wesishiyagalolunye kusibonelo esingenhla).

#VALUE! - Ivela uma ingxabano engeyona inombolo (umugqa ayisishiyagalombili kusibonelo).

Excel QUOTIENT ImiSebenzi Yokusebenza

Esikhathini esingenhla, izibonelo zibonisa izindlela eziningi ezahlukahlukene ukuthi umsebenzi we-QUOTIENT ungasetshenziswa ukuhlukanisa izinombolo ezimbili uma kuqhathaniswa nefomula lesigaba.

Imiphumela yefomula yokuhlukanisa esitokisini B4 ibonisa kokubili i-quotient (2) nalokho okusele (0.4) ngenkathi i-QUOTIENT isebenza kumaseli B5 no-B6 ubuyela kuphela inombolo yonke nakuba izibonelo ezimbili zihlukanisa izinombolo ezimbili ezifanayo.

Ukusebenzisa ama-Arrays njengama-Arguments

Enye indlela yokusebenzisa i- array yezingxabano zomsebenzi owodwa noma ngaphezulu njengoba kuboniswe kulayini 7 ngenhla.

I-oda elilandelwa umsebenzi uma usebenzisa izigcawu:

1. umsebenzi kuqala uhlukanisa izinombolo ku-hlu ngalunye:
   • 100/2 (impendulo ka-50);
   • 4/2 (impendulo ye-2)
2. umsebenzi bese usebenzisa imiphumela yesinyathelo sokuqala ngezinkulumo zawo:
   • Isibalo: 50
   • I-Denominator: 2
   emsebenzini wokuhlukanisa: 50/2 ukuthola impendulo yokugcina engu-25.

Isebenzisa umsebenzi we-QUOTIENT we-Excel

Izinyathelo ezingezansi kwekhava zingena emsebenzini we-QUOTIENT nezimpikiswano zayo ezisefenjini B6 yesithombe ngenhla.

Izinketho zokufaka umsebenzi kanye neziphakamiso zalo zifaka:

• Ukuthayipha umsebenzi ophelele: = QUOTIENT (A1, B1) esitokisini B6 futhi
• Ukukhetha umsebenzi kanye nokuphikisana kwawo usebenzisa ibhokisi lebhokisi lebhokisi le-QUOTIENT.

Nakuba kungenzeka nje ukuthayipha umsebenzi ophelele ngesandla, abantu abaningi bakuthola kulula ukusebenzisa ibhokisi lengxoxo ukuze bafake izingxabano zomsebenzi.

Qaphela: Uma ufaka lo msebenzi ngesandla, khumbula ukuhlukanisa zonke izingxabano nama-commas.

Ukufaka umsebenzi we-QUOTIENT

Lezi zinyathelo zimboza ukungena emsebenzini we-QUOTIENT kuseli B6 usebenzisa ibhokisi lengxoxo lomsebenzi.

1. Chofoza kuseli B6 ukuze wenze iseli elisebenzayo - indawo lapho imiphumela yefomula izoboniswa khona.
2. Chofoza kuthebhu yefomathi yebhande .
3. Khetha i- Math & Trig kusuka kubhoni ukuze uvule uhlu lwehla lokusebenza.
4. Chofoza ku- QUOTIENT ohlwini ukuze ulethe ibhokisi lengxoxo lomsebenzi.
5. Ebhokisini lengxoxo, chofoza kulayini weNumerator .
6. Chofoza ku-cell A1 kushidi lokusebenzela ukuze ufake leli referensi yeseli ebhokisini lengxoxo.
7. Ebhokisini lengxoxo, chofoza kulayini weDominator .
8. Chofoza kuseli B1 kushidi lokusebenzela.
9. Chofoza OK ku-ibhokisi lengxoxo ukuze ugcwalise umsebenzi bese ubuyela ekhasini lokusebenzela.
10. Impendulo 2 kufanele ibonakale esitokisini B6, kusukela ngo-12 ehlukaniswe ngu-5 inombhalo ophelele we-2 (khumbula ukuthi okusele kulahlekelwa umsebenzi).
11. Uma uchofoza ku-cell B6, umsebenzi ophelele = QUOTIENT (A1, B1) uvela kubha yefomula ngaphezulu kwephepha lokusebenzela.