Ukudibanisa imisebenzi ye-ROUND kunye ne-SUM kwi-Excel

Ukuhlanganiswa kwemisebenzi emibini okanye ngaphezulu - njengeROUND kunye neSUM - kwifomula esisodwa kwi-Excel ibedla ngokubizwa ngokuba yimisebenzi yokwakha .

Ukuhlalisa kufezwa ngokuba nomsebenzi omnye usebenza njengengxabano yomsebenzi wesibini.

Kumfanekiso ongentla:

• Umzekelo kumqolo wesithandathu unomsebenzi we-SUM osebenza njengengxabano yeNombolo yomsebenzi we-ROUND.
• I-Row yesisixhenxe inemiSebenzi ye-ROUND emininzi njengemigangatho yesigqibo somsebenzi we-SUM.

Ukudibanisa imisebenzi ye-ROUND kunye ne-SUM kwi-Excel

Ukususela kwi-Excel 2007, inani lamanqanaba emisebenzi enokuthi linywe ngaphakathi ngaphakathi li-64.

Ngaphambi kwesi siqendu, iinqanaba eziyisixhenxe kuphela zokuvumba zavunyelwa.

Xa uvavanya imisebenzi enamathele, i-Excel isebenza ngokusisigxina okanye ingaphakathi ngaphakathi kwaye isebenze indlela yayo ngaphandle.

Ngokuxhomekeke kumyalelo weemisebenzi ezimbini xa zidibene,

• Imizila okanye iikholomu zedatha zingabiniswa kwaye zijikelezwe kwinani elihleliweyo leendawo ezigqibeleleyo zonke ngaphakathi kweseli yeshidi elilodwa, umqolo wesithandathu ngentla.
• Iimilinganiselo zingabalwa kuqala kwaye zidibanise, umqolo wesisixhenxe ngaphezulu.
• Iimilinganiselo zingabalwa kuqala kwaye zidibanise, zonke kwiiselinye enye usebenzisa i- formula ye-SUM / ROUND eneempahla ezikhethiweyo , umqolo wesibhozo ngaphezulu.

Nangona iifomula kwimigangatho yesithandathu ukuya kweyesibhozo zivelisa iziphumo ezifanayo, umyalelo wemisebenzi enesidima ingaba luleke.

Iziphumo zeempompo kwimigangatho yesithandathu neyezisixhenxe zihluke ngexabiso ngo-0.01 kuphela, ezinokuthi okanye ezingabonakali ngokubhekiselele kwiimfuneko zedatha.

I-ROUND / SUM Ifomula yomzekelo

Amanyathelo angezantsi ajonga indlela yokufaka ifom yeROUND / SUM esele kwiseli B6 kumfanekiso ongentla.

= I-RUM (ISUM (A2: A4), 2)

Nangona kunokwenzeka ukungena ifom epheleleyo, abantu abaninzi bakuthola kulula ukusebenzisa ibhokisi yencoko yencoko yomsebenzi ukuba bafake ifomu kunye neengxabano.

Ibhokisi yencoko yencoko yenza lula ukungena kwiingxoxo zomsebenzi omnye ngexesha ngaphandle kokukhathazeka nge- syntax yomsebenzi - njengabazali abazungeze iingxabano kunye neefasta ezenza njengabahluli phakathi kweengxabano.

Nangona umsebenzi we-SUM unayo ibhokisi yencoko yababini, ayinakusetyenziswa xa umsebenzi udibene ngaphakathi komnye umsebenzi. I-Excel ayivumeli ibhokisi yencoko yebhokisi evulekileyo xa ivula ifom.

1. Cofa kwifowuni B6 ukuze wenze iseli esebenzayo.
2. Cofa kwiThebhu yefomula yerbhoni .
3. Cofa kwiMat & Trig kwimenyu ukuvula uluhlu lwehla lokuhla.
4. Cofa kwiROUND kwiluhlu ukuvula ibhokisi yencoko yencoko ye-ROUND.
5. Cofa kwiNombolo yomgca kwibhokisi yencoko.
6. Uhlobo lwe- SUM (A2: A4) ukufaka umsebenzi we-SUM njengengxoxo yeNombolo yomsebenzi we-ROUND.
7. Cofa kwi- Num_digits umgca kwibhokisi yencoko.
8. Thayipha i- 2 kulo mgca ukuze ujikeleze impendulo yomsebenzi we-SUM kwiindawo ezi-2 zesidanga.
9. Cofa u- OK ugcwalise ifomu uze ubuyele kwiphepha lokusebenzela.
10. Impendulo ye-764.87 ifanele ivele kwiseli ye-B6 ekubeni siyijikelezile isamba sedata kwiiseli D1 ukuya kwi-D3 (764.8653) ukuya kwiindawo ezi-2 ezide.
11. Ukuqakraza kwiseli C3 kuya kubonisa umsebenzi odibeneyo
    = I-ROUND (SUM (A2: A4), 2) kwifom yefomula ngaphezu kwephepha lokusebenzela.

I-SUM / ROUND I-Array okanye i-CSE ifomu

Ifomula eqhelekileyo, njengaleyo kwi-B8 yeseli, ivumela ukubala amaninzi kwenzeke kwiseli yomsebenzi omnye.

Ifomula equlathekileyo iqondwa ngokulula ngamabhonki okanye iibrackets {} ezizungeze ifom. Ezi bhonkco azifakiweyo, nangona kunjalo, kodwa zingenwe ngokucinezela i Shift + Ctrl + Faka izitshixo kwikhibhodi.

Ngenxa yezitshixo ezisetyenziselwa ukuzenza, amafomula ahlukeneyo ngamanye amaxesha abizwa ngokuba ngamaCMS amafomula.

Iifomula zomdlalo zifakwe ngaphandle kokunceda ibhokisi yencoko yencoko yomsebenzi. Ukufaka ifom ye-SUM / ROUND kwifrayili kwi-cell B8:

1. Cofa kwifowuni B8 ukwenza iseli esebenzayo.
2. Thayipha kwifom = ROUND (SUM (A2: A4), 2).
3. Cinezela kwaye ubambe iqhosha leShift + Ctrl kwikhibhodi.
4. Cinezela kwaye ukhulule ukhiye wokungena kwikhibhodi.
5. Ixabiso eli-764.86 kufuneka livele kwiseli yeB8.
6. Ukuqakraza iseli B8 kuza kubonisa ifom yokulandelelana
   {= I-ROUND (SUM (A2: A4), 2)} kwibha yefom.

Ukusebenzisa iROUNDUP okanye iROUNDDOWN Endaweni

I-Excel ineminye imisebenzi emibini yokujikeleza efana nomsebenzi weROUND - ROUNDUP kunye neROUNDDOWN. Le mi sebenzi isetyenziswe xa ufuna ixabiso lijikelezwe kwicandelo elithile, kunokuba lithembele kwimithetho yokuqokelela i-Excel.

Ekubeni iimbambano zombini wale mi sebenzi zifana nezo zomsebenzi weROUND, nokuba lula ukutshintshwa kwisalathisi esingasentla apha kumqolo wesithandathu.

Ifom ye-ROUNDUP / SUM ifom iya kuba:

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

Ifom ye-ROUNDDOWN / SUM ifom iya kuba:

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