Izinombolo ezizungezile kuze kube ku-5 noma 10 eziseduze kakhulu ku-Excel

01 ka 01

Umsebenzi we-Excel CEILING

I-CEILING Umsebenzi Kafushane

Umsebenzi we-Excel we-CEILING ungasetshenziselwa ukuqeda izindawo ezingadingekile zesimanje noma amadijithali angadingekile kwedatha ngokushaya izinombolo eziphezulu kuze kube nenani eliseduzane elibhekwa njengokubalulekile.

Isibonelo, umsebenzi ungasetshenziselwa ukuzungeza inomboro phezulu ukuya ku-5, 10, noma eminye ecacisiwe.

Iningi lezinombolo lingathathwa ngokushesha ngokubala ngenombolo. Isibonelo, ama-5, 10, 15, no-20 yizo zonke iziphindaphindwe ezingu-5

Ukusetshenziswa okuwusizo kulo msebenzi ukuhlanganisa izindleko zezinto kudoti eliseduzane ($ 0.10) ukuze ugweme ukubhekana nokushintsha okuncane njengama-pennies ($ 0.01) nama-nickels ($ 0.05).

Qaphela: Ukuze uhambise izinombolo phezulu ngaphandle kokucacisa inani lokuzungeza, sebenzisa umsebenzi we- ROUNDUP .

Ukuguqula Idatha ngemisebenzi ye-Rounding

Njengeminye imisebenzi yokujikeleza, umsebenzi we-CEILING uyaguqula idatha kushidi lakho lokusebenzela futhi, ngakho-ke kuyothinta imiphumela yanoma yikuphi ukubalwa okusebenzisa amanani ahambisanayo.

Ngakolunye uhlangothi, kukhona okukhethwa kukho ukufometha ku-Excel okuvumela ukuthi ushintshe inombolo yezindawo zamadesimali eziboniswa idatha yakho ngaphandle kokushintsha izinombolo ngokwabo.

Ukwenza ushintsho lokufometha kwedatha alinamthelela kubalo.

I-Syntax ye-Function ye-CEILING ne-Arguments

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

I-syntax yomsebenzi we-CEILING yile:

= I-CEILING (Inombolo, Okubalulekile)

Inombolo - inani elizofakwa. Le mpikiswano ingaqukatha idatha yangempela yokuqoqa noma ingaba ireferensi yeseli endaweni yedatha ekhasini lokusebenzela.

Okubalulekile - inani lezindawo zamadesimali ezikhona kule ngxabano kubonisa inombolo yezindawo zedesimali noma amadijithi abalulekile azoba khona emphumela (imigqa yesi-2 no-3 yesibonelo)
- umsebenzi ujikeleza ukuphikisana kwenombolo okuchazwe ngenhla kuze kufike multiple multiple of this value
- uma inamba isetshenziselwa le mpikiswano zonke izindawo zedesimali kulo mphumela zizosuswa futhi umphumela uzothengiswa ku-multiple multiple of this value (umugqa wesi-4 wesibonelo)
- ngenxa yeziphakamiso zezinombolo ezingalungile nezimpikiswano eziqondile zokubaluleka , imiphumela ihambelana phezulu kuya ku-zero (imigqa 5 no-6 yesibonelo)
- ngenxa yezingqinamba zezinombolo nezindinganiso ezingalungile Okubalulekile , imiphumela ihlehlisiwe phansi ukusuka ku-zero (umugqa wesi-7 wesibonelo)

Izibonelo ze-CEILING Umsebenzi

Isibonelo esithombeni ngenhla sisebenzisa umsebenzi we-CEILING ukuze ujikeleze amanani amaningana wedesimali kuya ku-integer elandelayo.

Umsebenzi ungangenwa ngokuthayipha igama lomsebenzi neziphakamiso kumakhalekhukhwini oyifunayo noma ungangena usebenzisa ibhokisi lengxoxo lomsebenzi njengoba kuchazwe ngezansi.

Izinyathelo ezisetshenziselwa ukufaka umsebenzi kumakhalekhukhwini C2 ziyi:

1. Chofoza kuseli C2 ukuze wenze iseli elisebenzayo - yilapho imiphumela yomsebenzi we-CEILING izoboniswa khona
2. Chofoza kuthebhu yefomula yemenyu ye- ribbon
3. Khetha i- Math & Trig kusuka kubhoni ukuze uvule uhlu lwehla lokusebenza
4. Chofoza ku- CEILING kuhlu ukuze ulethe ibhokisi lengxoxo lomsebenzi
5. Ebhokisini lengxoxo, chofoza kulayini lombhalo
6. Chofoza ku-cell A2 kusikripthi sokusebenzela ukuze ufake leyo reference yocingo ebhokisini lengxoxo
7. Ebhokisini lengxoxo, chofoza kulayini lokubaluleka
8. Thayipha ku-0.1
9. Chofoza OK ukuqedela umsebenzi bese uvala ibhokisi lengxoxo
10. Impendulo 34.3 kufanele ivele kuseli C2
11. Uma uchofoza ku-cell E1 umsebenzi ophelele = CEILING (A2, 0.1) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela

Indlela i-Excel efika ngayo kule mpendulo yilezi:

• okokuqala kususa idijithi eyodwa engadingekile (2) kusukela ekupheleni kwenombolo - indawo eyodwa yedesimali ku-Impikiswano yokubalulekile kusho indawo eyodwa yedesimali emphumela
• Ngokulandelayo lizungeza inombolo ehleliyo yale nombolo kuze kufike ku-34.3 ngoba lokhu kuhamba phambili okuphezulu kwe-0.10 emva kwe-34.2

I-Cell C3 kuya ku-C7 imiphumela

Uma izinyathelo ezingenhla ziphindaphindiwe kumaseli C3 kuya eC7, imiphumela elandelayo iyatholakala:

• iseli C3 iqukethe inani 34.25, ngoba izindawo ezimbili zesimangadi ku-argument Yokubaluleka zidinga izindawo ezimbili zedesimali emphumela futhi 34.25 yiyona elandelayo ephezulu kakhulu ka-0.05 ngemuva kwe-34.22
• iseli C4 iqukethe inani 35, njengoba i-argument Yokubaluleka iyinani eliphelele, zonke izindawo zesimanje zikhishwa emphumela futhi 35 yi-multiple elandelayo ephezulu kakhulu emva kokungu-34
• iseli C5 iqukethe inani -34.2 ngezizathu ezifanayo ezichazwe iseli C2
• iseli C6 iqukethe inani - 34 ngezizathu ezifanayo njenge cell C4
• iseli C7 iqukethe ukubaluleka -35, ukuhlanganisa ukuphikisana kwenombolo engalungile kanye nenani elibi le-argument yokubaluleka isusa zonke izindawo zedesimali futhi lizungeza umphumela phansi kwe-multiple of 1 emva -34

#NUM! Inani lephutha

I-# NUM ! Iphutha lemali libuyiselwa yi-Excel yomsebenzi we-CEILING uma i-argument yenombolo enhle ihlangene nengxabano engalungile yokubaluleka .