Izinombolo ezizungezile eziya ku-5 noma 10 eziseduze ku-Google

Umsebenzi we-Google Spreadsheets 'UMROUND wenza kube lula ukuzungeza inombolo phezulu noma phansi ukuya ku-5, 10, noma enye ecacisiwe.

Isibonelo, lo msebenzi ungasetshenziselwa ukunciphisa noma ukwehla izindleko zezinto kumasenti amahlanu aseduzane (0.05) noma amasenti ayishumi (0.10) ukuze ugweme ukubhekana nama-pennies (0.01) njengenguquko.

Ngokungafani nezinketho zokufometha ezivumela ukuthi ushintshe inombolo yezindawo zedesimali eziboniswa ngaphandle empeleni ukushintsha inani esitokisini, umsebenzi we-MROUND, njengeminye imisebenzi ye-Google Spreadsheets, iyashintsha ukubaluleka kwedatha.

Ukusebenzisa lo msebenzi ukuzungeza idatha kuyobe kuthinta imiphumela yezibalo.

Qaphela: Ukuze uhambise izinombolo phezulu noma phansi ngaphandle kokucacisa inani lokuzungeza, sebenzisa imisebenzi ye- ROUNDUP noma ye-ROUNDDOWN kunalokho.

01 ngo-04

I-syntax yomsebenzi we-MROUND ne-Arguments

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

I-syntax yomsebenzi we-MROUND ngu:

= UMROMO (inani, isici)

Amaphuzu alo msebenzi yilezi:

inani - (elidingekayo) inombolo ezobanjelwa noma phansi ukuya kwenani elikude

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

isici - (esidingekayo) umsebenzi ujikeleza ukuxabana kwenani eliphakeme noma eliphansi kunani elikude leli nani.

Amaphuzu okuphawula ngokuphathelene nezimpendulo zomsebenzi yilezi:

• uma ukuphikisana kwe - factor kushiywe, iphutha le- # N / A kuseli eliqukethe umsebenzi.
• i- factor kanye ne- value arguments kufanele ibe nesibonakaliso esifanayo - kungaba okuhle noma okungalungile. Uma kungenjalo, lo msebenzi ubuyisela #NUM! iphutha kuseli.
• uma i- factor kanye ne- value value arguments zombili zingalungile, umsebenzi ubuyisela inombolo embi esitokisini njengoba kuboniswe emgqeni amane esithombeni ngenhla.
• uma ingxabano yesici isethelwe ku-zero (0), umsebenzi ubuyisela inani le-zero esitokisini njengoba kuboniswe emgqeni wesikhombisa kusifanekiso ngenhla.

02 ka 04

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

Kungakhathaliseki ukuthi idijithi yokugcina noma integer (idijithi yokujikeleza) ihlanganiswe noma ihlelwe kuncike ekuxabaneni kwenani .

• Uma idijithi yokujikeleza nazo zonke izinombolo ezingakwesokudla sayo ekuxabaneni kwexabiso zingaphansi kwesigamu inani lempikiswano yezinto, umsebenzi ujikeleza idijithi yokugcina phansi.
• Uma idijithi yokujikeleza nazo zonke izinombolo ezingakwesokudla sayo ekuxabaneni kwenani elikhulu kunenani noma lilingana nesigamu sokubaluleka kokuphikisana kwezinto , idijithali yokujikeleza ihlanganisiwe.

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

• Kulayini 8, njengoba ingxabano ye factor is integer eyodwa integer, i-2 iba idijithali yokubala in inombolo 12.50 value esitokisini A8. Kusukela ku-2.5 kufana nengxenye yenani lempikiswano ye-factor (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 ye-factor (5.00), lo msebenzi ujikeleza umphumela kuze kube ngu-10.00, okuyinto ehamba phambili ye-5.00 ngaphansi kwe-12.49.

03 ka 04

Ukufaka umsebenzi we-MROUND

I-Google Spreadsheets ayisebenzisi amabhokisi okuxoxa ukuze ufake izingqinamba zomsebenzi njengoba zingatholakala ku-Excel. Esikhundleni salokho, inebhokisi elikhombisa ukuzenzekelayo eliphambuka njengoba igama lomsebenzi lifakwe esitokisini.

1. Faka idatha elandelayo ku- cell A1: 4.54
2. Chofoza kuseli C2 kushidi lokusebenzela ukwenza kube iseli elisebenzayo - yilapho imiphumela yomsebenzi we-MROUND izoboniswa khona
3. Thayipha uphawu olulinganayo (=) olulandelwe igama lomsebenzi ombalwa
4. Njengoba uthayipha, ibhokisi eliphakamisa ngokuzenzakalelayo livela ngamagama wemisebenzi eqala ngencwadi M
5. Uma igama MROUND livela ebhokisini, chofoza igama nge pointer yegundane ukufaka igama lomsebenzi bese uvula ibakaki nxazonke e-cell C2

04 ka 04

Ukufaka Ukungqubuzana Komsebenzi

Imibono yomsebenzi we-MROUND ingenwa ngemuva kokusikweleka okuvulekile kwiseli C2.

1. Chofoza ku-cell A2 kusikripthi sokusebenza ukuze ufake leli khenferensi yeseli njengengxabano yexabiso
2. Faka i-comma ukuba uhlukanise phakathi kweziphakamiso zomsebenzi
3. Thayipha u-0.05 ukungena kule nombolo njengengxabano yesici
4. Cindezela ukhiye wokungena kwikhibhodi ukungena ibhakha lokuvala " ) " emva kokuphikisana komsebenzi futhi ukuqedela umsebenzi
5. Inani elingu-4.55 kufanele livele esitokisini B2, okuyinto ehamba phambili ye-0.05 emikhulu kunama-4.54
6. Uma uchofoza ku-cell C2 umsebenzi ophelele = UMROUND (A2, 0.05) uvela kubha yefomula ngaphezulu kwephepha lokusebenzela