Ukuhlanganisa imisebenzi ye-ROUND ne-SUM ku-Excel

Ukuhlanganisa ukusebenza kwemisebenzi emibili noma ngaphezulu - njengeROUND ne-SUM - ngesifomula esisodwa ku-Excel kuvame ukubizwa ngokuthi imisebenzi yokudoba .

Ukuqothulwa komzimba kufezwa ngokuba nomsebenzi owodwa ukwenza njengokuphikisana komsebenzi wesibili.

Esithombeni ngenhla:

• Isibonelo emgqeni wesi-6 sinomsebenzi we-SUM osebenza njengengxabano yeNombolo yomsebenzi we-ROUND.
• Umzila wesikhombisa unemisebenzi eminingi e-ROUND njengezingqinamba zeNombolo yomsebenzi we-SUM.

Ukuhlanganisa imisebenzi ye-ROUND ne-SUM ku-Excel

Kusuka ku-Excel 2007, inani lamazinga emisebenzi engadliwa ngaphakathi phakathi kwengu-64.

Ngaphambi kwalolu nguqulo, amazinga ayisikhombisa kuphela okuvunyelwayo okuvunyelwe.

Uma uhlola imisebenzi eyakhiwe, i-Excel isebenza kuqala kakhulu noma isebenze ngaphakathi futhi isebenze indlela yayo ngaphandle.

Kuye ngokuhleleka kwemisebenzi emibili lapho kuhlangene,

• Imigqa noma amakholomu wedatha angagcwaliswa bese ehlanganiswa nenani elihleliwe lezindawo zedesimali konke ngaphakathi kweseli elilodwa lokusebenzela, irowu eyisithupha ngenhla.
• Izindinganiso zingaboshwa kuqala bese zifingqa, umugqa wesikhombisa ngaphezulu.
• Izindinganiso zingahle zihlangane bese zifingqwa, konke kuseli elilodwa usebenzisa i-SUM / ROUND umdwebo ohlanganisiwe womugqa, umugqa ongaphezu kwesishiyagalombili ngenhla.

Ngisho noma amafomu emigqeni eyisithupha kuya kweyisishiyagalombili akhiqiza imiphumela efana kakhulu, ukuhleleka kwemisebenzi eyakhiwe kungabalulekile.

Imiphumela yefomula emigqeni ayisithupha nesikhombisa ihluke ngokulinganisa ngo-0.01 kuphela, okungenzeka noma okungabi yiyo ngokubaluleka kuye ngezidingo zedatha.

I-ROUND / SUM I-Formula Isibonelo

Izinyathelo ezingezansi zihlanganisa indlela yokufaka ifomula ROUND / SUM esesitokisini B6 esithombeni ngenhla.

= INHLANGANO (i-SUM (A2: A4), 2)

Nakuba kungenzeka ukufaka ifomula ephelele ngesandla, abantu abaningi bakuthola kulula ukusebenzisa ibhokisi lengxoxo lomsebenzi ukuze bafake ifomula nezimpikiswano.

Ibhokisi lengxoxo lenza kube lula ukufaka izingxabano zomsebenzi ngesikhathi esisodwa ngaphandle kokukhathazeka mayelana ne- syntax yomsebenzi - njengabazali abazungezile izingxabano kanye nama-commas enza njengabahlukanisi phakathi kwezimpikiswano.

Ngisho noma umsebenzi we-SUM unebhokisi lengxoxo yakhe, angeke isetshenziswe uma umsebenzi uhlelwe ngaphakathi komunye umsebenzi. I-Excel ayivumeli ibhokisi lengxoxo yesibili ukuthi livule lapho lifakwa ifomula.

1. Chofoza kuseli B6 ukuze wenze iseli esebenzayo.
2. Chofoza kuthebhu yefomathi yebhande .
3. Chofoza ku- Math & Trig kwimenyu ukuvula uhlu lwehla lokusebenza.
4. Chofoza ku- ROUND ohlwini ukuze uvule ibhokisi lokusebenza lomsebenzi we-ROUND.
5. Chofoza kulayini Inomboro ebhokisini lengxoxo.
6. Thayipha i- SUM (A2: A4) ukungena umsebenzi we-SUM njengengxabano yeNombolo yomsebenzi we-ROUND.
7. Chofoza kumugqa we- Num_digits ebhokisini lengxoxo.
8. Thayipha i- 2 kulolu hlangothi ukuze ujikeleze impendulo emsebenzini we-SUM ezindaweni ezingu-2 zedesimali.
9. Chofoza u- Kulungile ukuqedela ifomu bese ubuyela ekhasini lokusebenzela.
10. Impendulo engu-764.87 kufanele ibonakale esitokisini B6 njengoba sesiqedile inani lemininingwane kumaseli D1 kuya ku-D3 (764.8653) ezindaweni ezingu-2 zedesimali.
11. Ukuchofoza esitokisini C3 kuzobonisa umsebenzi ocebile
    = UMHLANGANO (SUM (A2: A4), 2) kwibha yefomula ngaphezulu kwephepha lokusebenzela.

I-SUM / ROUND I-Array noma i-CSE Formula

Ifomula elandelanayo, njengaleyo esesitokisini se-B8, ivumela ukubala okuningi kuzokwenzeka kuseli elilodwa lomsebenzi weshidi.

Ifomula ehlanganisiwe ibonakala kalula ngama-braces noma amabakaki aphethwe yi- {} azungeze ifomula. Lezi zibambo azifakiwe ngaphakathi, kodwa, kodwa zingenwe ngokucindezela okhiye be- Shift + Ctrl + Enter ekhibhodi.

Ngenxa yezihluthulelo ezisetshenziselwa ukuzakha, amafomu amahle athile abizwa ngokuthi ama-CSE amafomula.

Amafomula afanayo avame ukufakwa ngaphandle kosizo lwebhokisi lengxoxo yomsebenzi. Ukufaka ifomula ye-SUM / ROUND yamathuluzi esitokisini B8:

1. Chofoza kuselili B8 ukuze lenze iseli elisebenzayo.
2. Thayipha kwifomula = ROUND (SUM (A2: A4), 2).
3. Cindezela bese ubamba okhiye be- Shift + Ctrl ekhibhodi.
4. Cindezela bese ukhulula ukhiye wokungena kwikhibhodi.
5. Inani 764.86 kufanele livele esitokisini B8.
6. Ukuchofoza esitokisini B8 kuzobonisa ifomula yamalungu
   {= ROUND (SUM (A2: A4), 2)} kubha yefomula.

Usebenzisa i-ROUNDUP noma i-ROUNDDOWN esikhundleni

I-Excel ineminye imisebenzi emibili yokujikeleza efana kakhulu nomsebenzi we-ROUND - ROUNDUP no-ROUNDDOWN. Le misebenzi isetshenziswe uma ufuna amanani ukuba ahlotshwe esiqondisweni esithile, kunokuthembela emithethweni yokuqoqa i-Excel.

Njengoba izimpikiswano zombili lezi zenzo zifana nezo zomsebenzi we-ROUND, kungenzeka kalula zifakwe endaweni ehlongozwe ngenhla emgqeni wesithupha.

Ifomu lefomula ye-ROUNDUP / SUM kungaba:

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

Ifomu le-formula ye-ROUNDDOWN / SUM kungaba:

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