I-Numeri ejikelezayo ukuya kwi-5 okanye i-10 e-Excel

01 ngo 01

I-Excel CEILING Umsebenzi

CEILING Umsebenzi Umsebenzi

Umsebenzi we-CEILING we-Excel ungasetyenziselwa ukuqeda iindawo ezingapheliyo zokugqibela okanye iinombolo ezingabalulekanga kwidatha ngokukhawulela amanani ukuya phezulu kwixabiso elikufutshane elithathwa njengelibalulekileyo.

Ngokomzekelo, umsebenzi ungasetyenziselwa ukujikeleza inani ukuya phezulu ukuya ku-5, 10, okanye enye echaziweyo.

Uninzi lweqela linokumisela ngokukhawuleza ngokubala ngenani. Umzekelo, 5, 10, 15, kunye no-20 yiyo yonke i-multiples ye-5

Ukusetyenziswa okusebenzayo kumsebenzi kukuhlawulela indleko zezinto kwi-dime efuphiweyo ($ 0.10) ukuphepha ukujongana neenguqu ezincinci ezifana neepennies ($ 0.01) kunye nama-nickel ($ 0.05).

Qaphela: Ukwenza amanani ajikelezayo ngaphandle kokucacisa inani lokujikeleza, sebenzisa umsebenzi weROUNDUP .

Ukutshintsha iDatha kunye neMisebenzi yokuHlola

Njengeminye imisebenzi yokujikeleza, umsebenzi we-CEILING uguqula idatha kwiphepha lakho lokusebenzela kunye nokuthanda, ngoko kuyachaphazela iziphumo zazo naziphi na izibalo ezisetyenzisiweyo.

Kukho, ngakolunye uhlangothi, ukhetho lokufometha kwi-Excel oluvumela ukuba utshintshe inani leendawo zokugqibela eziboniswe ngedatha yakho ngaphandle kokutshintsha amanani ngokwabo.

Ukwenza ukutshintshwa kwefomathi kwiedatha akukho mpembelelo kubalo.

I-Synilx ye-CEILING yeMisebenzi kunye neArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano .

I-syntax yomsebenzi we-CEILING yile:

= I-CEILING (Inani, Ubaluleka)

Inombolo - ixabiso lokuhlaziywa. Le ngxabano ingaba nedatha yangempela yokujikeleza okanye ingaba yereferensi yeseli kwendawo yedata kwiphepha lokusebenzela.

Ukubaluleka - inani leendawo zokugqibela ezikhoyo kule ngxabano kubonisa inani leendawo ezidlulileyo okanye amadijithi amaninzi aya kuba khona kwisiphumo (imiqolo 2 kunye no-3 womzekelo)
- umsebenzi ujikeleze ingxabano yeNombolo echazwe ngasentla ukuya kwi-multiple value yeli xabiso
- ukuba inani elipheleleyo lisetyenziselwa le ngxabano zonke izithuba eziphambili kwisiphumo ziya kususwa kwaye isiphumo siya kuhlanganiswa kwiqela elikufutshane le xabiso (umgca 4 womzekelo)
- ngenxa yeengxabano zeNombolo kunye neengxelo ezifanelekileyo zokubaluleka , iziphumo zijikeleze phezulu ukuya kwi-zero (imiqolo 5 no-6 yomzekelo)
- ngenxa yeengxabano zeNombolo kunye neengxelo ezingekho phantsi kwezinto ezifanelekileyo, iziphumo zijikelezwe ngaphantsi ukusuka kwi-zero (umgca wesi-7 womzekelo)

CEILING Umsebenzi weMisebenzi

Umzekelo kumfanekiso ongentla usetyenziswa umsebenzi we-CEILING ukujikeleza ixabiso elithile leemali ezide ukuya kwinani elilandelayo.

Umsebenzi ungangeniswa ngokuchwetheza igama lomsebenzi kunye neengxabano kwiseli elifunayo okanye kungeniswa usebenzisa ibhokisi yencoko yomsebenzi njengoko kuchazwe ngezantsi.

Amanyathelo asetyenziswa ukufaka umsebenzi kwiseli C2 yile:

1. Cofa kwiseli C2 ukwenzela ukuba yenze i- cell esebenzayo- yilapho iziphumo zomsebenzi we-CEILING ziza kuboniswa
2. Cofa kwiTrafom ithebhu yemenyu yebhondi
3. Khetha i- Math & Trig kwi-ribbon ukuvula uluhlu lwehla lokuhla
4. Cofa kwi- CEILING kuloluhlu ukukhupha ibhokisi yencoko yencoko yomsebenzi
5. Kwibhokisi yencoko, nqakraza kumgca weNombolo
6. Cofa kwifowuni A2 kwiphepha lokusebenzela ukuze ufake ifowuni yeefayile kwibhokisi yencoko
7. Kwibhokisi yencoko, nqakraza kwiNgcaciso yomgca
8. Thayipha kwi-0.1
9. Cofa u-OK ukugqiba umsebenzi kwaye uvale ibhokisi yencoko
10. Impendulo 34.3 ibonakale kwiseli C2
11. Xa ucofa kwi-cell E1 umsebenzi opheleleyo = CEILING (A2, 0.1) ibonakala kwifom yefomula ngaphezulu kwiphepha lokusebenzela

Indlela i-Excel efika ngayo kule mpendulo yile:

• Okokuqala isusa enye idijithi engabalulekanga (2) ukusuka ekupheleni kwenombolo - indawo enye yedesimali kwingxabano ebalulekileyo ithetha indawo eyodwa kuphela yokugqibela kwisiphumo
• Ngalandelayo lijikeleza idijithi eseleyo yeenombolo ukuya kwi-34.3 kuba eli liqela elilandelayo eliphezulu le-0.10 emva kwe-34.2

Iziphumo zeCS C3 ukuya kwiC7

Ukuba amanyathelo angentla angaphinda aphindwe kwiiseli C3 ukuya ku-C7, ezi ziphumo zilandelayo zifumaneka:

• iseli C3 iqulethe ixabiso 34.25, kuba iindawo ezimbini zokugqibela kwiingxabano eziyimfuneko zidinga indawo ezimbini ezigqibeleleyo kwisiphumo kwaye 34.25 yiyona elandelayo ephezulu ye-0.05 emva kwe-34.22
• Iselfowuni C4 iqulethe ixabiso 35, kuba ingxabano yokubaluleka iyinani elipheleleyo, zonke izithuba eziqingqiweyo zisuswe kwisiphumo kwaye i-35 yiyona elandelayo ephezulu emva kwe-1 emva kwe-34
• iseli C5 iqulethe ixabiso -34.2 ngezizathu ezifanayo ezichazwe kwi-cell C2
• I-cell C6 iqulethe ixabiso-34 ngezizathu ezifanayo njengeseli C4
• iseli C7 iqulethe ixabiso -35, ukudibanisa i-argument yenombolo engalunganga kunye nenani elibi leNkcazo ebalulekileyo ikhupha zonke iindawo zokugqibela kunye nokujikeleza isiphumo ukuya kwiqela elilandelayo elilandelayo -34

#NUM! Iphutha lexabiso

# NUM ! Ixabiso lephutha libuyiselwa yi-Excel yomsebenzi we-CEILING ukuba inqaku elihle leNombolo lidibaniswe nengxabano engabalulekanga.