Iyo QUOTIENT inoshanda muExcel inogona kushandiswa kuita basa rekuparadzanisa pane nhamba mbiri, asi iyo inongodzorera chikamu chikamu (nhamba yose chete) semugumisiro, kwete yekusara.
Hapana "kuparadzanisa" basa muExcel iyo ichakupa iwe wose nhamba yakazara uye chikamu chepakati chemhinduro.
- Kuti uite basa rekuparadzanisa nguva dzose apo nhamba yose uye yakasara inodzorerwa, shandisa mazano ekuparadzanisa .
- Kudzorera chete zvakasara - chikamu chiduku kana chikamu chekushanda kwechikamu - shandisa maMOD basa .
- Basa rakafanana ndiyo inhengo yeC INT - iyo inowanzokomberedza nhamba kusvika kune imwe nhamba yakakwana-inogona kushandiswa kubvisa chikamu chechikamu chechikamu chechikamu.
IQUOTIENT Function ya Syntax uye Arguments
Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemavara, uye nharo .
Mutsara we QUOTIENT basa ndewokuti:
= QUOTIENT (Numerator, Denominator)
Numerator (inodikanwa) - chikamu (chikoro chakanyorwa pamberi pekushanda slash ( / ) mubasa rekuparadzanisa).
- Iyi nharo inogona kunge iri nhamba chaiyo kana sechitinho chetare kunzvimbo yedhadha mune pepaji.
Denominator (inodiwa) - iyo divisor (nhamba yakanyorwa mushure mekuenderera mberi kwekushanda mumabasa ekuparadzanisa). Iyi nharo inogona kunge iri nhamba chaiyo kana sechitinho chetare kunzvimbo yedhadha mune pepaji .
QUOTIENT Function Errors
# DIV / 0! - Inoitika kana dhinominator nharo yakaenzana ne zero kana zvinyorwa pasina bhokisi (row nine mumuenzaniso uri pamusoro).
#VALUE! - Inosvika kana imwe nharo isiri nhamba (mutsara we8 mumuenzaniso).
Excel QUOTIENT Function Examples
Mumufananidzo uri pamusoro, mienzaniso inoratidza nzira dzakasiyana-siyana iyo QUOTIENT basa inogona kushandiswa kupatsanura nhamba mbiri kana ichienzanisa neyamupiro yekuparadzanisa.
Zvigumisiro zvekuparadzanisa kwemukati mumasero B4 zvinoratidza zvose quotient (2) uye zvakasara (0.4) apo QUOTIENT inoshanda mumasero B5 uye B6 inodzoka chete nhamba yose kunyange zvazvo miviri miviri iri kugovana nhamba mbiri dzakafanana.
Kushandisa Arrays seArguments
Imwe nzira ndeyekushandisa mhando imwechete kana mamwe emashoko ekushanda sezvakaratidzwa mumutsara 7 pamusoro apa.
Urongwa hwakatevedzerwa nehutano kana uchishandisa mabhora ndeokuti:
- basa iro rokutanga rinoparadzanisa nhamba mumhando imwe neimwe:
- 100/2 (mhinduro ye50);
- 4/2 (mhinduro ye2)
- basa racho rinoshandisa zvikamu zvekutanga kwezvikonzero zvaro:
- Numerator: 50
- Denominator: 2
Kushandisa Excel QUOTIENT Function
Matanho ari pasi apa anopinda mu QUOTIENT basa uye nharo dzayo dziri muchitokisi B6 chemufananidzo pamusoro apa.
Zvisarudzo zvekupinda mubasa uye nharo dzayo dzinosanganisira:
- Kunyora basa rakakwana: = QUOTIENT (A1, B1) muchikamu B6 uye
- Kusarudza basa uye mazano aro uchishandisa QUOTIENT basa dialog box .
Kunyange zvazvo zvichibvira kungonyora basa rakakwana riri muruoko, vanhu vazhinji vanozviona zviri nyore kushandisa bhokisi rebhokisi kuti vapinde nharo dzebasa.
Cherechedza: Kana uchinge wapinda basa racho pachako, yeuka kuparadzanisa nharo dzose nemagetsi.
Kupinda QUOTIENT Basa
Aya matanho anovhara kupinda mu QUOTIENT basa mumusero B6 uchishandisa basa rebhokisi rebhokisi.
- Dzvanya pane sero B6 kuti riite sero rinoshandiswa - nzvimbo iyo migumisiro yefomu icharatidzwa.
- Dzvanya paMafomu tab yebhoni .
- Sarudza Math & Trig kubva kubhoni kuti uzarure basa rakaderera pasi.
- Dzvanya pa QUOTIENT muburusita kuti ubudise bhokisi rebasa rebasa.
- Mubhokisi rebhokisi, tora pane Numerator line.
- Dzvanya pachitokisi A1 mune pepa rekushanda kuti uise iyi seferensi yekero mubhokisi rebhokisi.
- Mubhokisi rebhokisi, tora paDenominator line.
- Dzvanya pane sero B1 mubasa rekushanda.
- Dzvanya OK mubhokisi rebhokisi kuti upedze basa uye dzokera kushizha remabasa.
- Mhinduro 2 inofanira kuonekwa muchitokisi B6, sezvo 12 yakapatsanurwa ne5 ine mhinduro yose yenhamba 2 (yeuka zvakasara zvarasikirwa nebasa).
- Paunenge uchitsvaga pane cell B6, basa rakakwana = QUOTIENT (A1, B1) rinowanikwa mubhadha yepamusoro pane pepa rekushanda.