Izinombolo ezizungezile eziya ku-Even Integer eziseduze ku-Excel

01 ka 01

Umsebenzi we-Excel EVEN

Umsebenzi we-EVEN we-EVEN ungasetshenziselwa ukudonsa izindinganiso zamadayimenti ku-integer ngisho ngenkathi ususa ingxenye yedesimali yenombolo.

Njengoba kuboniswe kukholomu C esithombeni esingenhla, zonke izindinganiso - kungakhathaliseki ukuthi zikhona futhi zingavamile - zihlanganiswe ngisho nezinombolo ngokusebenza.

Ukunciphisa ama-Positive namaNombolo angalungile

Lo msebenzi awuhambisani nemigomo yokuqeda ukuthi imisebenzi eminingi ye-Excel yokulandelela ilandelwa. Esikhundleni salokho, ihlale ijikeleza izinombolo kude ne-zero kungakhathaliseki ukuthi inombolo ayinayo noma ayihle.

Ukuguqulwa kwemiphumela ye-zero ezinombolweni ezihle zihlangene kuze kube yilapho ephakeme kunazo zonke ngisho nenani elikhulu kungakhathaliseki ukubaluleka kwedijithi yokuqoqa ngenkathi izinombolo ezingezansi zihlelwe phansi kunani eliphansi kunazo zonke.

Esithombeni esingenhla, amanani angu-6.023 no-7.023 ahlanganisiwe kuze kube ngu-8 kuyilapho amanani -6.023 no -7.023 ehlelwe phansi -8.

Idatha Yokubala Nezibalo

Ngokungafani nezinketho zokufometha eziguqula ukubonakala kwedatha ngokushintsha inani lezindawo zamadesimali ezibonisiwe; umsebenzi we-EVEN uguqulela idatha kuphepha lokusebenzela .

Umsebenzi we-EVEN, ngakho-ke, ungathinta imiphumela yezinye izibalo kushidi lokusebenza elisebenzisa idatha ehambelanisiwe.

I-syntax ye-EVEN kanye nama-Arguments

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

I-syntax yomsebenzi we-EVEN yile:

= EVEN (Inombolo)

Inombolo - (edingekayo) inani elizobanjelwa. Le mpikiswano ingaqukatha idatha yangempela yokuqoqa noma ingaba ireferensi yeseli endaweni yedatha ekhasini lokusebenzela.

IZIMPENDULO ZemiSebenzi

Isibonelo esithombeni ngenhla sisebenzisa umsebenzi we-EVEN ukuzungeza amanani amaningana wedesimali kuya ku-integer elandelayo.

Umsebenzi ungangena ngokuthayipha igama lomsebenzi nokuphikisana 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-EVEN izoboniswa
2. Chofoza kuthebhu yefomula yemenyu ye- ribbon
3. Khetha i- Math & Trig kusuka kubhoni ukuze uvule uhlu lwehla lokusebenza
4. Chofoza ku- EVEN ohlwini ukuze ukhulise ibhokisi lengxoxo lomsebenzi
5. Ebhokisini lengxoxo, chofoza kulayini lombhalo
6. Chofoza ku- cell A2 kusikripthi sokusebenzela ukuze ufake leyo reference yocingo ebhokisini lengxoxo
7. Chofoza OK ukuqedela umsebenzi bese uvala ibhokisi lengxoxo
8. Impendulo engu-8 kufanele ivele esitokisini C2 ngoba lokhu kuyona ephakeme kunazo zonke noma iningi emva kwe-6.023
9. Uma uchofoza ku-cell C2 umsebenzi ophelele = EVEN (A2) uvela kubha yefomula ngaphezulu kwephepha lokusebenzela

Ukukopisha Iforomu Ngesandla Sokugcwalisa

Esikhundleni sokuphinda uphinde ulandelele ezinye izibonelo ezintathu, ifomula yokuqala ingalandelwa ngokushesha usebenzisa isibambo sokugcwalisa noma ukopishe bese unamathele kusukela ingxabano yomsebenzi we-EVEN ingenwe njengesithenjwa esisezingeni elihlobene .

Imiphumela yalolu msebenzi kufanele ibe:

• Amaseli C3 no-C5 kufanele abe ne-value -8 ngoba lena iyona ephansi kunazo zonke ngisho nenani elilandelayo ngemuva kwamanani -6.023 no -7.023;
• I-Cell C4 kufanele iqukathe inani le-8, eliyisikhulu esilandelayo nakakhulu ngemva kwe-7.023.

#VALUE! Inani lephutha

I-#VALUE! inani lephutha libuyiselwa uma i-Excel ingayiboni idatha efakwe kwi- Arguments Number njengenombolo. Esinye isichazamazwi kungenzeka ukuthi izinombolo zingenwe njengedatha yombhalo .