Fomu yeSinita uye kushandiswa kweMOD
I-MOD inoshanda , pfupi nokuda kwe modulo kana modulus inogona kushandiswa kuparadzanisa nhamba mu Excel. Zvisinei, kusiyana nekuparadzanisa nguva dzose, MOD inoshanda chete inopa iwe sarudzo semhinduro. Zvishandiso zvebasa iri muExpcel zvinosanganisira kuisunganidza pamwe nekugadzirisa mafungiro ezvimwewo kuti zvive nemimwe mutsara uye shave yepamusoro , izvo zvinoita kuti zvive nyore kuverenga mabhuku makuru e data.
Basa reMOD Mutsara neArguments
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .
Izwi rechiito cheMOD rinotevera:
= MOD (Nhamba, Kurambana)kupi Nhamba ndiyo nhamba iri kugoverwa uye Kuparadzanisa ndiyo nhamba yaunoda kuparadzanisa nhamba yeNhamba.
Nhamba nhamba inogona kuva nhamba inopindirwa zvakananga mubasa kana sechitinhare chekuona panzvimbo ye data pane pepa .
Basa reMOD rinodzoka # DIV / 0! kukanganisa kwenhamba yemamiriro ezvinhu anotevera:
- Kana zero inopinda muDisisor argument
- Kana sero rinoshandiswa kune sevha risina kuvharwa rakapinda muChikamu chekuparadzanisa
Kushandisa Excel & # 39; s MOD Basa
- Isa data inotevera inesei inoratidzwa. Muchitokisi D1, pinda nhamba 5. Muchitokisi D2, tumira nhamba 2.
- Dzvanya pane cell E , nzvimbo iyo migumisiro icharatidzwa.
- Dzvanya paMafomu tab yebhoni .
- Sarudza Math & Trig kubva kubhoni kuti uzarure urongwa hwekuderera pasi.
- Dzvanya paMOD murugwaro kuti ubudise bhokisi rebasa rebasa.
- Mubhokisi rebhokisi, tora paNhamba yemurongo.
- Dzvanya pane cell D1 pane pepa rekushanda.
- Mubhokisi rebhokisi, chengeta paDisitori mutsara.
- Dzvanya pane cell D2 pane spreadsheet.
- Dzvanya OK kana Wakaitwa mubhokisi rebhokisi.
- Mhinduro 1 inofanira kuonekwa muchitokisi E1 kubvira pakaparadzaniswa ne2 mashizha musara we1.
- Paunenge uchinyora pane cell E1 zvakakwana basa = MOD (D1, D2) inowanikwa mubhadha yepamusoro pane pepa pepaji.
Sezvo MOD inoshanda chete inodzorera zvakasara, chikamu chakakwana chebasa rekuparadzanisa (2) haritauri. Kuti uratidze integer sechikamu chemhinduro, unogona kushandisa QUOTIENT basa .