Msonkhano wa Malamulo ndi Kugwiritsa Ntchito MOD
MOD imagwira , yochepa kwa modulo kapena modulus ingagwiritsidwe ntchito kugawa manambala mu Excel. Komabe, mosiyana ndi magawano nthawi zonse, MOD imakupatsani inu otsalira monga yankho. Kugwiritsira ntchito ntchitoyi ku Excel kumaphatikizapo kuyanjana ndi maonekedwe ovomerezeka kuti apange mzere wina ndi mzere wamtundu , zomwe zimapangitsa kuti kukhale kosavuta kuwerengera zigawo zazikulu za deta.
Ntchito ya MOD Syntax ndi Arguments
Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .
Chidule cha ntchito ya MOD ndi:
= MOD (Nambala, Kugawa)kumene Chiwerengero ndi chiwerengero chogawanika ndi Kugawanitsa ndi nambala yomwe mukufuna kugawana nambala ya Nambala.
Chigamulo cha Nambala chingakhale nambala yomwe imalowa mwachindunji ku ntchito kapena selo loyang'ana pa malo a deta mu kapepala .
Ntchito ya MOD imabwerera # DIV / 0! malingaliro olakwika pa zinthu zotsatirazi:
- Ngati zero yalowa muzitsutso za Gawano
- Ngati mawonekedwe a selo kwa selo lopanda kanthu alowetsedweratu pa mkangano Wopatukana
Kugwiritsira Ntchito Excel & # 39; s MOD Ntchito
- Lowetsani deta zotsatirazi mu maselo omwe amasonyeza. Mu selo D1, lowetsani nambala 5. Mu selo D2, lowetsani nambala 2.
- Dinani pa selo E , malo omwe zotsatira zidzawonetsedwa.
- Dinani pa Fomu tab ya riboni .
- Sankhani Math & Trig kuchokera paboni kuti mutsegule ntchito yolemba pansi.
- Dinani pa MOD mndandanda kuti mubweretse bokosi lazokambirana .
- Mu bokosi la bokosi, dinani pa Nambala .
- Dinani pa selo D1 pa tsamba la ntchito.
- Mu bokosi la bokosi, dinani pazowonjezera.
- Dinani pa selo D2 pa spreadsheet.
- Dinani KULI KOPEREKA KAPENA KOPEREKEDWA M'BUKU LABWINO
- Yankho 1 liyenera kuoneka mu selo E1 chiyambire 5 kugawidwa ndi 2 masamba otsala a 1.
- Mukasindikiza pa selo E1 ntchito yonse = MOD (D1, D2) ikuwoneka muzenera zamatabwa pamwamba pa tsamba.
Popeza kuti MOD imagwira ntchito yokhayo yobwezeretsa zotsalazo, gawo lochepa la ntchito yogawidwa (2) sichiwonetsedwa. Kuti muwonetse chiwerengero ngati gawo la yankho, mungagwiritse ntchito QUOTIENT ntchito .