Umsebenzi we-Excel UMOUNDOUND

Umsebenzi we-MROUND we-Excel wenza kube lula ukuzungeza inombolo ngenhla noma phansi ukuya kuziphindaphinda ze-5, 10, noma enye enye into ecacisiwe.

Isibonelo, umsebenzi ungasetshenziselwa ukugoqa noma wehla izindleko zezinto eziseduze:

• amasenti amahlanu (0.05)
• amasenti ayishumi (0.10)

ukugwema ukubhekana nama-pennies (0.01) njengenguquko.

Ngokungafani nezinketho zokufometha ezivumela ukuthi ushintshe inombolo yezindawo zedesimali eziboniswa ngaphandle kokuguqula inani esitokisini, umsebenzi we-MROUND, njengeminye imisebenzi ye- Excel, iguqula inani lemininingwane.

Ukusebenzisa lo msebenzi ukuzungeza idatha kuyobe kuthinta imiphumela yezibalo.

I-syntax yomsebenzi we-MROUND ne-Arguments

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .

I-syntax yomsebenzi we-ROUNDDOWN yile:

= UMROMO (Inombolo, Iningi)

Amaphuzu alo msebenzi yilezi:

Inombolo - (edingekayo) inombolo okumele ihlanganiswe noma ihlelwe kunani elikude

• Le mpikiswano ingaqukatha idatha yangempela yokuqoqa noma ingaba ireferensi yeseli endaweni yedatha ekhasini lokusebenzela .

I-Multiple - (edingekayo) umsebenzi ujikeleza ukuphikisana kwenombolo phezulu noma phansi kuya kulesisilinganiso esiseduze sale nzuzo.

Amaphuzu okuphawula ngokuphathelene nezimpendulo zomsebenzi yilezi:

• Inombolo nezimpikiswano eziningi kufanele zibe nesibonakaliso esifanayo - sibe siphutha noma sibi. Uma kungenjalo, lo msebenzi ubuyisela #NUM! iphutha kuseli.
• uma Inombolo nezimpikiswano eziningi zingamabili, umsebenzi ubuyisela inombolo engena esitokisini njengoba kuboniswe emgqeni amane esithombeni esingenhla.
• uma i-Arguments Multiple isethwe ku-zero (0), umsebenzi ubuyisela inani le-zero esitokisini njengoba kuboniswe emgqeni wesikhombisa esithombeni esingenhla.

Izibonelo Zezinhlelo ze-MROUND

Emfanekisweni ngenhla, ngezibonelo eziyisithupha zokuqala, inombolo 4.54 ihlanganiswe noma iphansi ngomsebenzi we-MROUND usebenzisa amazinga ahlukahlukene wezingxabano zesici ezifana no-0.05, 0.10, 5.0, 0, no-10.0.

Imiphumela iboniswa kukholomu C kanye nefomula eveza imiphumela kukholomu D.

Ijikeleza noma ihle

Ngokwesifayela sosizo lwe-Excel, ukuthi lo msebenzi unquma kanjani ukuthi ukuzungeza idijithi yokugcina esele (idijithali yokujikeleza) phezulu noma phansi kuncike ekuphumeni okuphumela ekuhlukaniseni ukuphikisana kwenombolo nge-argument Multiple.

• Uma lo mphumela ukhulu kunanoma yikuphi noma ulingana nengxenye yenani lempikiswano eminingi, umsebenzi ujikeleza idijithali yokugcina (kude ne-zero).
• Uma lo mphumela ungaphansi kwengxenye yenani lempikiswano eminingi, umsebenzi ujikeleza idijithali yokugcina phansi (kuya ku-zero).

Izibonelo ezimbili zokugcina - emgqeni 8 no-9 wesithombe - zisetshenziselwa ukukhombisa ukuthi lo msebenzi uphatha kanjani ukujikeleza noma phansi.

• Eceleni kuka-8, njengoba i-Arguments Multiple iyinani lezinombolo elilodwa, i-2 iba yidijithi yokujikeleza ngenani le-12.50 elisezingeni leselula A8. Kusukela ku-2.5 kulingana nengxenye yenani lempikiswano yama-Multiple (5.00), umsebenzi ujikeleza umphumela kuze kufike ku-15.00, okuyinto ehamba phambili ye-5.00 engaphezu kwe-12.50.
• Emgqeni we-9, kusukela ku-2.49 ingaphansi kwengxenye yenani lempikiswano eminingi (5.00), umsebenzi ujikeleza umphumela we-10.00, okuyi-multiple of 5.00 ngaphansi kwe-12.49.

Isibonelo Ukusebenzisa umsebenzi we-MOUND ROUND

Izinketho zokufaka umsebenzi kanye neziphakamiso zalo zifaka:

1. Ukuthayipha umsebenzi ophelele: njengokuthi = UMROMO (A2,0.05) kufinyelela kuseli lomsebenzi.
2. Ukukhetha umsebenzi nemibono yayo usebenzisa ibhokisi lokusebenza lomsebenzi we-MROUND.

Abantu abaningi bakuthola kulula ukusebenzisa ibhokisi lengxoxo ukuze bafake izingxabano zomsebenzi njengoba kuthatha ukunakekelwa kwe-syntax yomsebenzi - njengama-commas enza njengabahlukanisi phakathi kwezimpikiswano.

Izinyathelo ezingezansi kwekhava usebenzisa ibhokisi lengxoxo ukuze ufake umsebenzi ojikelezayo ube yi-cell C2 yesibonelo ngenhla.

1. Chofoza kuseli B2 ukuze wenze iseli esebenzayo .
2. Chofoza kuthebhu yefomathi yebhande .
3. Chofoza ku- Math & Trig icon ukuze uvule uhlu lwehla lokusebenza.
4. Chofoza ku- MROUND ohlwini ukuze uvule ibhokisi lengxoxo lomsebenzi.
5. Ebhokisini lengxoxo, chofoza kulayini lombhalo.
6. Chofoza kuseli ye-A2 kusikripthi sokusebenza ukuze ufake leli khenferensi yeseli njenge- Arguments Number .
7. Ebhokisini lebhokisi, chofoza kulayini oluningi .
8. Thayipha ku-0.05 - inombolo e-A2 izobe isungulwe noma iphinde iphinde ibe ne-multiple cents eseduze.
9. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela.
10. Inani elingu-4.55 kufanele livele esitokisini B2, okuyinto ehamba phambili ye-0.05 emikhulu kunama-4.54.
11. Uma uchofoza ku-cell C2 umsebenzi ophelele = UMROUND (A2, 0.05) uvela kubha yefomula ngaphezulu kwephepha lokusebenzela.