Mawerengedwe Ozungulira Kupita ku 5 kapena 10 pafupi kwambiri ku Excel

01 ya 01

Ntchito ya Excel CEILING

KUWERENGA NTCHITO Ntchito

Ntchito ya CEILING ya Excel ingagwiritsidwe ntchito kuthetsa malo osadalirika kapena malo osawerengeka mu deta pozungulira manambala kupita kumtengo wapafupi womwe umawoneka kuti ndi wofunikira.

Mwachitsanzo, ntchitoyi ikhoza kugwiritsidwa ntchito kuzungulira nambala kupita kumtunda wapafupi, 5, kapena wina wapadera.

Mapepala angapo angapangidwe mwamsanga powerengera ndi chiwerengero. Mwachitsanzo, 5, 10, 15, ndi 20 onse ndi ochulukitsa asanu

Ntchito yogwiritsira ntchito ntchitoyi ndi kuyendetsa mtengo wa zinthu pafupipafupi ($ 0.10) kuti mupewe kuthana ndi kusintha kochepa monga penseni ($ 0.01) ndi ma nickels ($ 0.05).

Zindikirani: Kuti muwerengere mawerengedwe osawerengera , musagwiritse ntchito ntchito ya ROUNDUP .

Dongosolo Kusintha ndi Ntchito Yoyendetsa

Monga ntchito zina zowonongeka, ntchito ya CEILING yeniyeni imasinthira deta yanu pazomwe mukuchita ndipo idzakhudza zotsatira za mawerengedwe omwe amagwiritsira ntchito miyezo yozungulira.

Pali, pambali ina, zosankha zojambula mu Excel zomwe zimakulolani kusintha chiwerengero cha malo osungidwa omwe akuwonetsedwa ndi deta yanu osasintha manambala okha.

Kupanga kusintha kwa mapangidwe kwa deta sikukhala ndi zotsatira pa mawerengedwe.

Syntax ndi Arguments Funso la CEILING

Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .

Chidule cha CEILING ntchito ndi:

= CEILING (Nambala, Kufunika)

Chiwerengero - mtengo wozungulira. Mtsutso uwu ukhoza kukhala ndi deta yeniyeni yozungulira kapena ikhoza kutanthauzira selo kwa malo a deta muzenera.

Kutanthawuza - chiwerengero cha malo apamwamba omwe alipo mu mtsutso uwu chikuwonetsa chiwerengero cha malo apamwamba kapena ziwerengero zazikulu zomwe zidzakhalapo mu zotsatira (mizere 2 ndi 3 ya chitsanzo)
- ntchitoyi imayendera ndondomeko ya chiwerengero chomwe chili pamwambapa kufika pafupipafupi
- ngati chiwerengero chikugwiritsidwa ntchito pazitsutsano zonse malo osankhidwa mu zotsatira zichotsedwa ndipo zotsatira zake zidzasinthidwa ku zambiri zapafupizi (mzere 4 wa chitsanzo)
- chifukwa cha nambala yolakwika ndi zifukwa zabwino Zokambirana zofunika, zotsatira zake zapitirira kumapeto kwa zero (mizere 5 ndi 6 ya chitsanzo)
- chifukwa cha nambala yosatsutsika ndi zolakwika Zofunikira zotsutsana, zotsatira zake zatsikira pansi kuchoka ku zero (mzere 7 wa chitsanzo)

CEILING Ntchito Zitsanzo

Chitsanzo mu chithunzi pamwambapa chimagwiritsa ntchito CEILING ntchito kuyendetsa mitengo yambiri ya decimal mpaka yotsatira ngakhale integer.

Ntchitoyi ingalowetsedwe mwa kulemba dzina la ntchito ndi zokambirana mu selo lofunidwa kapena zingalowe ntchito pogwiritsa ntchito bokosi la bokosi monga momwe tafotokozera m'munsimu.

Njira zomwe zimagwiritsidwa ntchito kulowa mu selo C2 ndi izi:

1. Dinani pa selo C2 kuti mupange selo yogwira ntchito - izi ndi zomwe zotsatira za CEILING ntchito zidzawonetsedwa
2. Dinani pa Fomu tab ya menyu yowonjezera
3. Sankhani Math & Trig kuchokera ku riboni kuti mutsegule ntchito yolemba pansi
4. Dinani pa CEILING mu mndandanda kuti mubweretse bokosi lazokambirana
5. Mu bokosi la bokosi, dinani pa Nambala
6. Dinani pa selo A2 mu tsamba lothandizira kuti mulowetse selolo mu bokosi la dialog
7. Mu bokosi la bokosi, dinani pa mzere wofunika
8. Sakani mu 0.1
9. Dinani OK kuti mutsirize ntchitoyi ndi kutseka bokosi la bokosi
10. Yankho 34.3 liyenera kuoneka mu selo C2
11. Mukasindikiza pa selo E1 ntchito yonse = CEILING (A2, 0.1) imawoneka mu barra yazenera pamwamba pa tsamba

Momwe Zomwe zimakhalira pa yankho ili ndi:

• Choyamba chimachotsa chiwerengero chimodzi chochepa (2) kuchokera kumapeto kwa chiwerengero - malo amodzi mu ndondomeko yofunikira imatanthauza malo amodzi okha
• Potsatira izo zikuzungulira chiwerengero chotsalira cha chiwerengerocho mpaka 34.3 popeza ichi ndicho chotsatira kwambiri cha 0.10 pambuyo pa 34.2

Zotsatira za C3 mpaka C7

Ngati ndondomeko zapamwambazi zikubwerezedwa kwa maselo C3 mpaka C7, zotsatira izi zikupezeka:

• selo C3 liri ndi mtengo 34.25, popeza malo awiri osankhidwa mu ndondomeko yowonjezera amafunika malo awiri osankhidwa mu zotsatira ndipo 34.25 ndi yotsatira yotsatira ya 0.05 pambuyo pa 34.22
• selo C4 liri ndi mtengo 35, chifukwa mtsutso Wofunika ndi chiwerengero, malo onse osungidwa amachotsedwa ku zotsatira ndipo 35 ndi yotsatira yambiri ya 1 pambuyo pa 34
• selo C5 liri ndi mtengo -34.2 pa zifukwa zomwezo zomwe zafotokozedwa pa selo C2
• selo C6 liri ndi mtengo - 34 chifukwa chimodzimodzi monga selo C4
• selo C7 liri ndi mtengo -35, kuphatikizapo nambala ya nambala yolakwika ndi chiwerengero chotsutsa cha mtsutso wofunika kuchotsa malo onse osungira ndi kuzungulira zotsatirapo mpaka maola ambiri otsatira pambuyo -34

#NUM! Kulakwitsa kwa Mtengo

# #! Mphamvu yachinyengo imabweretsedwa ndi Excel kwa ntchito CEILING ngati ndondomeko yowonjezera yowonjezera ikuphatikizidwa ndi ndondomeko yosafunikira .