Kubatanidza ROUND uye SUM Mabasa mu Excel

Kubatanidza kushanda kwemashure maviri kana kupfuura - zvakadai seROUND uye SUM - mune imwe nzira muExcel inowanzotumidzwa senzvimbo yekuita nesting .

Nesting inopedzerwa nokuva nebasa rimwe chete kuita sepikisano chechipiri basa.

Mumufananidzo uri pamusoro apa:

• Muenzaniso mumutsara wechitanhatu une basa reSUM riri kuita seNhamba yeNhamba yebasa ROUND.
• Rowanomwe rine zvakawanda ROUND rinoshanda seNhamba nharo dzeSUM basa.

Kubatanidza ROUND uye SUM Mabasa mu Excel

Kubvira paExcel 2007, nhamba yezvikamu zvemabasa zvinogona kuva nendere mukati memumwe kune 64.

Pamberi peiyi shanduro, maitiro manomwe chete ekugadzira dendere akabvumidzwa.

Kana uchitarisa zvinhu zvakasvibiswa, Excel inogara ichiita yakadzika kana kuti mukati mukati mekutanga uye inoshandisa nzira yayo kunze.

Zvichienderana nehutano hwemabasa maviri kana akabatanidzwa,

• Mitsara kana zvinyorwa zvemashoko zvinogona kupfupiswa uye zvadaro zvakapoteredzwa nhamba yakatarwa yenzvimbo dzepamusoro zvose zviri mukati memusero webasa rimwe chete, mutsara matanhatu pamusoro apa.
• Mitemo inogona kutanga yakapoteredzwa uye inopfupikiswa, mutsara wechinomwe kumusoro.
• Mitemo inogona kutanga yakakomberedzwa uye yobva yapfupiswa, yose mune rimwe sero uchishandisa SUM / ROUND nested array formula , mutsara we8 pamusoro apa.

Kunyange zvazvo mitsara mumiganhu mitanhatu kusvika kune masere inobereka zvibereko zvakafanana zvakafanana, urongwa hwebasa rakagadzirwa hunogona kunge hunokosha.

Migumisiro yekuti maitiro mumitsara matanhatu neyechinomwe yakasiyana zvakakosha kuburikidza ne 0.01, iyo inogona kana kuti isingave yakakosha zvichienderana nezvinodiwa zve data.

ROUND / SUM Formula Example

Matanho ari pasi apa anowanikwa maitiro ekupinda muROUND / SUM formula iri muchitokisi B6 mumufananidzo uri pamusoro.

= RONDO (SUM (A2: A4), 2)

Kunyange zvazvo zvichikwanisika kupinda musangano wakakwana manually, vanhu vazhinji vanoona zviri nyore kushandisa bhokisi rebasa rebasa kuti vapinde mazano uye nharo.

Iyo bhokisi rinotaura zviri nyore kupinda maitiro ebasa rimwe chete pane imwe nguva pasina kushushikana pamusoro pebasa rekushanda - zvakadai sevabereki vanopoteredza nharo nemakasiti anoita separarator pakati pezvakaitika.

Kunyange zvazvo basa reSUM rine ine bhokisi rekukurukurirana, rinogona kushandiswa apo basa racho rakagadzirirwa mukati meimwe basa. Excel haibvumiri yechipiri yebhokisi yebhokisi kuti izaruriwe pavanopinda maitiro.

1. Dzvanya pane sero B6 kuti riite sero rinoshanda.
2. Dzvanya paMafomu tab yebhoni .
3. Dzvanya paMat & Trig mumenyu kuti uzarure basa redu rezasi.
4. Dzvanya paROUND mumutsetse kuti uzarure basa ROUND rebhokisi rebhokisi.
5. Dzvanya paNhamba mutsara mubhokisi rebhokisi.
6. Tora SUM (A2: A4) kupinda muSUM basa seNhamba yenyaya yeROUND basa.
7. Dzvanya pane Num_digits mutsara mubhokisi rebhokisi.
8. Tora a 2 mumutsara uyu kuitira kuti upoteredze mhinduro kune basa reSUM kusvika ku 2 decimal nzvimbo.
9. Dzvanya OK kuti upedze rondedzero uye dzokera kubasa rekushanda.
10. Mhinduro 764.87 inofanira kuonekwa muchitokisi B6 sezvo takabvisa chiyero chemashoko mumasero D1 kusvika kuD3 (764.8653) kusvika ku 2 decimal nzvimbo.
11. Kushanda pachitokisi C3 kucharatidza basa rakasikwa
    = RONDO (SUM (A2: A4), 2) mubhadharo yepamusoro pane pepa pepaji.

SUM / ROUND Array kana CSE Formula

Nzira yakasiyana-siyana, yakadai seyese muchitokisi B8, inobvumira kuverengeka kwakawanda kuti kuitwe mune imwe sero yepaeseji.

Mushonga wepamusoro unonyatsozivikaniswa nemabhonji kana mabheji akavharidzirwa {} anopoteredza fomu. Izvi hazvifananidzi mukati, zvisinei, asi zvakapindirwa nekudhinda Shift + Ctrl + Enter keys pa keyboard.

Nemhaka yekiyi dzinoshandiswa kuzvigadzira, maitiro akafanana dzimwe nguva anotumidzwa seCSE mazano.

Nzira dzakanyorwa dzinowanzopinda pasina rubatsiro rwebasa rebhokisi rebasa. Kuti upinde muSUM / ROUND rondedzero yomufaira muchitokisi B8:

1. Dzvanya pane sero B8 kuti riite sero rinoshanda.
2. Tora mu formula = ROUND (SUM (A2: A4), 2).
3. Dhinda uye gadzirai Shift + Ctrl makii pane keyboard.
4. Dhinda uye usununguke muIndo yekupinda pane keyboard.
5. Iko inosvika 764.86 inofanira kuonekwa muchitokisi B8.
6. Kushandura pane sero B8 kucharatidza mazano akafanana
   {= RONI (SUM (A2: A4), 2)} mumutsetse webha.

Achishandisa ROUNDUP kana ROUNDDOWN Pane

Excel ine mamwe mabasa maviri okukwirira ayo akafanana zvikuru neROUND ROUNDUP - ROUNDUP uye ROUNDDOWN. Izvi zvinoshandiswa paunoda hutano hukomberedzwa mune imwe nzira, pane kuvimba nemitemo yeExcel.

Sezvo zvikonzero zvezvinhu izvi zvose zviri zvakafanana nezvo zvebasa reROUND, zvingave zviri nyore kuiswa panzvimbo yepamusoro yakanyorwa pamusoro apa mumutsara wekutanga.

Mhando yeROUNDUP / SUM formula yaizova:

= ROUNDUP (SUM (A2: A4), 2)

Mhando yeROUNDDOWN / SUM formula yaizova:

= ROUNDDOWN (SUM (A2: A4), 2)