Kubva Numeri kune Vanoswedzerwa Kunyange Vakawanda muExpcel

01 ye 01

Excel ZVAUNOSA Basa

Excel EVEN basa rinogona kushandiswa kupoteredza mararamiro emadhora kune imwe nhamba apo uchibvisa chikamu chechi decimal che nhamba.

Sezvinoratidzwa muchitsauko C chiri mumufananidzo uri pamusoro, zvose zvinokosha-kana zvikasadaro uye zvisingaoneki-zvakapoteredzwa kunyange zvizere nemabasa.

Kupoteredza Positive vs. Negative Numeri

Basa racho harisi kutevera mitemo yekukomberedza kuti dzakawanda zveExcel mamwe mabasa ekukomba anotevera. Pane kudaro, nguva dzose inotenderera nhamba kubva kure zero pasinei nokuti nhamba haina kunaka here kana kuti yakanaka.

Kurwisana kubva kune zero kunobatsira nhamba dzakanaka dzakapoteredzwa kusvika kune imwe yakakwirira kupfuura iyo yose yakawanda pasinei nehuwandu hwehuwandu hwekukomberedza apo nhamba dzisina kunaka dzakapoteredzwa kusvika kune inotevera yakaderera kana yakawanda.

Mumufananidzo wepamusoro, hutsika 6.023 uye 7.023 dzakapoteredzwa kusvika 8 apo hutsika -6.023 uye -7.023 dzakaperedzwa kusvika -8.

Rounding Data uye Kuverenga

Kusiyana nekugadzirisa mafungiro ayo anongogadzirisa kuonekwa kwedhesi kuburikidza nekuchinja nhamba yedzimba dzekusimudza dzakaratidzwa; iyo EVEN basa inoshandura iyo data iri mune pepa rekushanda .

IEVEN basa rinogona, zvino, kuchinja migumisiro yezvimwe zviverengero mune pepa rekushandisa iro rinoshandisa dheedhi dhese.

Iko Syntax yeEENEN uye Arguments

Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .

Mutsara weEVEN basa nderokuti:

= ZUVA (Nhamba)

Nhamba - (inoda) kukosha kwekukomberedza. Iyi nharo inogona kuva nemashoko chaiwo ekukomberedza kana inogona kuva sero rinotarisa kune nzvimbo yedhesi iri mubhuku remabasa.

ZVAVAKENZWA KUNYANYA MITEMO

Muenzaniso uri mumufananidzo uri pamusoro unoshandisa basa reWENEN kutenderera huwandu hwemashoko ekupedzisira kusvika kune inotevera kunyange integer.

Basa racho rinogona kupindirwa nekunyora zita rebasa uye nharo mumusero unoda kana inogona kuiswa uchishandisa bhokisi rebasa rebasa sezvarondedzerwa pasi apa.

Matanho anoshandiswa kupinda muitiro muchitokisi C2 ndiwo:

1. Dzvanya pachitokisi C2 kuti uite sero rinoshandiswa - iyi ndiyo iyo migumisiro yeEVEN basa remuenzaniso icharatidzwa
2. Dzvanya paMafomu yebhu yebhoni yebhoni
3. Sarudza Math & Trig kubva kubhoni kuti uzarure basa rakaderera pasi
4. Dzvanya paZVAZVIMI mune urongwa kuti ubudise bhokisi rebasa rebasa
5. Mubhokisi rebhokisi, tora paNhamba yemurongo
6. Dzvanya pane sero A2 mune pepa rekushandisa kuti uise iyo seferensi mubhokisi rebhokisi
7. Dzvanya OK kuti upedze basa uye uvhare bhokisi rebhokisi
8. Mhinduro 8 inofanira kuonekwa muchitokisi C2 sezvo iyi ndiyo inotevera yepamusoro kana yakawanda mushure me 6.023
9. Paunenge uchinyora pachitsime C2 basa rakakwana = ZVA (A2) inowanikwa mubhairi yepamusoro pane pepa pepaji

Kukopa Mufomu Nekuzadza Handle

Panzvimbo pokudzokorora maitiro emamwe mienzaniso mitatu, chimiro chokutanga chinogona kukurumidza kunyoreswa kushandiswa kugadzirisa kana kunyora nekunyora kubva pakakakavadzana kweEVEN basa rakapinda senhengo inoshandiswa .

Migumisiro yebasa iri inofanira kuva:

• Mitsara C3 neC5 inofanira kuva nehuwandu -8 sezvo ichi ndicho chinotevera chakanyanya kudarika mushure mehutsika -6.023 uye -7.023;
• Cell C4 inofanira kuva nehuwandu hwe8, iyo inotevera yakakwirira kupfuura iyo yose mushure me 7.023.

#VALUE! Error Value

The #VALUE! kukanganisa kwekanako kunodzoserwa kana Excel isingazivi dhesi yepikicha yenhamba se nhamba. Imwe tsanangudzo inogona kuitika ingava nhamba dzakapinda semashoko ekunyora .