I-Formula Syntax nokusetshenziswa kwe-MOD
Umsebenzi we-MOD, omfushane we- modulo noma i- modulus ingasetshenziswa ukuhlukanisa izinombolo ku-Excel. Nokho, ngokungafani nokuhlukaniswa okuvamile, umsebenzi we-MOD unikeza kuphela okusele njengempendulo. Ukusetshenziswa kwalolu msebenzi ku-Excel kufaka ukuhlanganisa nokufometha okunemibandela ukukhiqiza umugqa ohlukile kanye ne-column shading , okwenza kube lula ukufunda amabhulokhi amakhulu edatha.
Umsebenzi we-MOD Syntax ne-Arguments
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .
I-syntax yomsebenzi we-MOD yilezi:
= I-MOD (Inombolo, i-Divisor)kuphi Inombolo yinombolo ehlukaniswe futhi i-Divisor iyinombolo ofuna ukuhlukanisa ngayo impikiswano yenombolo.
Ukuphikisana kwenombolo kungaba inombolo engenwe ngokuqondile emsebenzini noma esitokisini sebheksi endaweni yedatha kushidi lokusebenzela .
Umsebenzi we-MOD ubuyisela i- # DIV / 0! inani lephutha lemibandela elandelayo:
- Uma i-zero ingenwe ngxabano ye-Divisor
- Uma ireferensi yeseli kweseli elingenalutho ingenwe ngxabano ye-Divisor
Usebenzisa i-Excel & # 39; s MOD Umsebenzi
- Faka idatha elandelayo kumaseli abonisiwe. Esitokisini D1, faka inamba 5. Esitokisini D2, faka inombolo 2.
- Chofoza kuseli E , indawo lapho imiphumela izoboniswa khona.
- Chofoza kuthebhu yefomathi yebhande .
- Khetha i- Math & Trig kusuka ku-riboni ukuvula uhlu lokudonsa phansi lomsebenzi.
- Chofoza ku- MOD kuhlu ukuze ulethe ibhokisi lengxoxo lomsebenzi.
- Ebhokisini lengxoxo, chofoza kulayini lombhalo.
- Chofoza kuseli D1 ekhasini lokusebenzela.
- Ebhokisini lebhokisi, chofoza kulayini lokuhlukanisa .
- Chofoza kuseli D2 kuspredishithi.
- Chofoza OK noma Ufeze ebhokisini lengxoxo.
- Impendulo 1 kufanele ivele esitokisini E1 kusukela u-5 uhlukaniswe ngu-2 ushiya insalela ye-1.
- Uma uchofoza kumakhalekhukhwini E1 umsebenzi ophelele = MOD (D1, D2) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.
Njengoba i-MOD isebenza kuphela ebuyisela okusele, ingxenye enkulu ye-operation division (2) ayiboniswa. Ukuze ubonise inamba njengengxenye yempendulo, ungasebenzisa umsebenzi we- QUOTIENT .