01 ye 01
Excel CEILING Basa
KUDZIDZA Function Overview
Basa reEECELING reEexcel rinogona kushandiswa kubvisa nzvimbo dzisina kudiwa dzinzvimbo kana mazita asingakoshi mumatare nekukomberedza nhamba zvichikwira kusvika kune zvakakosha zvinokosha zvinonzi zvinokosha.
Semuenzaniso, basa rinogona kushandiswa kupoteredza nhamba kusvika kumusoro kune 5, 10, kana imwe yakatsanangurwa yakawanda.
A multiple of number can quickly be determined by counting by the number. Somuenzaniso, 5, 10, 15, uye 20 dzose dzakawanda dze 5
Kushandiswa kwebasa ndekukwikwidza mari yezvinhu kune imwe nzvimbo iri pedyo ($ 0.10) kuti usasangana nekuchinja kuduku kwakafanana ne pennies ($ 0.01) uye nickels ($ 0.05).
Cherechedza: Kuti nhamba dzese dzisimudze usingatauri chiyero chekukomba, shandisa basa ROUNDUP .
Kushandura Dhiyabhorosi neHotting Functions
Kufanana nemamwe mabasa ekukomberedza, basa re CEILING rakashandura dhidhiro mubasa rako rekuita uye richada , saka rinokanganisa migumisiro yezvimwe zviyero zvinoshandisa maitiro akaenzana.
Pane, kune rumwe rutivi, kuisa maitiro muExcel iyo inokubvumira kuti uchinje nhamba yedzimba dzepamusoro dzakaratidzwa nedheta rako usingashanduki nhamba pachavo pachavo.
Kuita maitiro ekugadzirisa kune deta hakusi kuitika pane kuverenga.
Iko Syntax Function uye Arguments
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .
Mutsara weEECILING basa ndewokuti:
= CEILING (Nhamba, Zvinokosha)
Nhamba - kukosha kwekukomberedza. Iyi nharo inogona kuva nemashoko chaiwo ekukomberedza kana inogona kuva sero rinotarisa kune nzvimbo yedhesi iri mubhuku remabasa.
Kukosha - nhamba yematunhu ekupedzisira ari munyaya ino inoratidza nhamba yezvimbo dzepamusoro kana nhamba dzinokosha dzichavapo mumugumisiro (mitsetse 2 ne3 yemuenzaniso)
- basa rinotenderera nharo yeNhamba yakataurwa pamusoro apa kusvika kune yakawanda yakawanda yeiyi kukosha
- kana integer inoshandiswa nekuda kwepikisano yese nzvimbo dzekupedzisira mumugumisiro ichabviswa uye chigumisiro chacho chichapoteredzwa kusvika kune yakawanda yakawanda yeiyo kukosha (mutsara 4 wemuenzaniso)
- nekuda kwechikonzero Nhamba nhaurirano uye nharo dzinofanirwa kujekesa, zvigumisiro zvakapoteredzwa zvichienda kumusoro kune zero (mitsetse 5 ne6 yomuenzaniso)
- nekuda kwezvisizvo Nhamba nharo uye zvisina kunaka Zviratidzo zvinopesana, zvigumisiro zvakapoteredzwa kubva kune zero (mutsara 7 wechienzaniso)
KUDZIDZA Basa Rakaitwa Mienzaniso
Muenzaniso uri mumufananidzo uri pamusoro unoshandisa CEILING basa rokutenderera huwandu hwemashoko ekupedzisira kune imwe inotevera kunyange integer.
Basa racho rinogona kupindirwa nekunyora zita rebasa uye nharo mumusero unoda kana kuti inogona kupinda mukati rebhokisi rebhokisi rebasa sezvakataurwa pasi apa.
Matanho anoshandiswa kupinda muitiro muchitokisi C2 ndiwo:
- Dzvanya pachitokisi C2 kuti uite sero inoshandiswa - iyi ndiyo iyo migumisiro ye CEILING basa icharatidzwa
- Dzvanya paMafomu yebhu yebhoni yebhoni
- Sarudza Math & Trig kubva kubhoni kuti uzarure basa rakaderera pasi
- Dzvanya pa CEILING mumutsara kuti uburise hurukuro yebhokisi rebasa
- Mubhokisi rebhokisi, tora paNhamba yemurongo
- Dzvanya pane sero A2 mune pepa rekushandisa kuti uise iyo seferensi mubhokisi rebhokisi
- Mubhokisi rebhokisi, chengetedza paChidimbu chekureva
- Tora mu 0.1
- Dzvanya OK kuti upedze basa uye uvhare bhokisi rebhokisi
- Mhinduro 34.3 inofanira kuonekwa muchitokisi C2
- Paunenge uchibvisa pane cell E1 zvakakwana basa = CEILING (A2, 0.1) inowanikwa mubhairi yepamusoro pane pepa rekushanda
Iyo Excel inosvika sei mhinduro iyi ndeyokuti:
- Chokutanga iyo inobvisa imwe nhamba isina kukwana (2) kubva pakuguma kwenhamba - imwe nzvimbo yepamusoro mumagariro ekukosha anongoreva nzvimbo imwe chete yemugumisiro mumugumisiro
- iri kutevera iyo inotenderera nhamba yakasara yenhamba kusvika kusvika 34.3 sezvo ichi ndicho chinotevera chakanyanya pane 0.10 mushure me 34.2
Cell C3 kusvika C7 migumisiro
Kana matanho ari pamusoro apa achidzokidzwa kumasero C3 kusvika kuC7, zvinotevera zvinowanikwa:
- Sero C3 rine chinyorwa 34.25, sezvo zvikamu zviviri zvekupedzisira muChirevo chekukosha zvinoda maviri nzvimbo dzekupedzisira mumugumisiro uye 34.25 ndiyo inotevera yakawanda ye 0.05 mushure me 34.22
- Sero C4 ine chiremera 35, sezvo Gwaro rekukosha ndiro integer, nzvimbo dzose dzekusimudza dzinobviswa kubva pamugumisiro uye 35 ndiyo inotevera yakanyanya kupfuura yega mushure mekunge 34
- Sero C5 ine chinyorwa -34.2 nokuda kwezvikonzero zvakafanana zvinotsanangurwa neC2
- Sero C6 rine chinyorwa-34 nokuda kwezvikonzero zvakafanana sechitokisi C4
- Sero C7 ine chinhu chinokosha -35, kubatanidza nhamba isina kunaka Nhamba uye nhamba yakaipa yeArbitentience argument inobvisa nzvimbo dzose dzepamusoro uye dzinotenderera chigumisiro kusvika kune imwe inotevera ye1 pashure -34
#NUM! Error Value
The # NUM ! kukanganisa kwekanako kunodzorerwa neExcel yeEECILING basa kana nharo yeNhamba yakanaka inosanganiswa nechinhu chisina kunaka.