Mawerengedwe Ozungulira kwa Otsatira Ngakhale Otsalira ku Excel

01 ya 01

Excel KUGWIRITSIDWA NTCHITO

Ntchito ya EVEN ya EVEN ingagwiritsidwe ntchito kuzungulira mitengo yamtengo wapatali mpaka ngakhale yochuluka pamene ikuchotsa gawo la decimal la chiwerengerocho.

Monga momwe zasonyezedwera m'mbali C mu chithunzi pamwambapa, zikhalidwe zonse - kaya ngakhale ngakhale zosamvetseka - zikuphatikizidwa ngakhale zokhudzana ndi ntchitoyo.

Kusuntha Zovuta ndi Mawerengero Olakwika

Ntchitoyi satsatira malamulo ozunguza ntchito zambiri zotsatizana za Excel. M'malo mwake, nthawi zonse zimakhala zowerengeka kutali ndi zero mosasamala kanthu kuti nambala ndi yoipa kapena yabwino.

Kupitiliza kuchoka ku zero kumabweretsa chiwerengero chokwanira chokwera kufika pamtsinje wotsatilapo mosasamala phindu la chiwerengero choyendetsa pamene nambala zosawerengeka zimatsitsikira kwa ochepa omwe ali ochepa kwambiri.

M'chifanizo pamwambapa, chiwerengero cha 6.023 ndi 7.023 chasungidwa mpaka 8 pamene zikhulupiliro -6.023 ndi -7.023 zatsikira mpaka -8.

Zosinthidwa ndi Mawerengedwe

Mosiyana ndi maonekedwe a maonekedwe omwe amangosintha maonekedwe a deta powasintha chiwerengero cha malo apamwamba omwe asonyezedwa; ntchito ya EVEN imasintha deta muzenera .

Ntchito ya EVEN ikhoza kukhudza zotsatira za mawerengedwe ena mu tsamba lomwe limagwiritsa ntchito deta yolumikizidwa.

Syntax ndi Ntchito Zowona

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

Chidule cha ntchito ya EVEN ndi:

= KODI (Nambala)

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

ZOYENERA Zitsanzo Zogwira ntchito

Chitsanzo mu chithunzi pamwambachi chimagwira ntchito ya EVEN kuyendetsa miyezo yambiri ya decimal mpaka yotsatira ngakhale integer.

Ntchitoyi ingalowetsedwe mwa kulemba dzina la ntchito ndi kukangana mu selo lofunidwa kapena likhoza kulowetsedwa pogwiritsa ntchito bokosi lazokambirana 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 ntchito ya EVEN idzawonetsedwa
2. Dinani pa Fomu tab ya menyu yowonjezera
3. Sankhani Math & Trig kuchokera ku riboni kuti mutsegule ntchito yolemba pansi
4. Dinani PAKATI PA 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. Dinani OK kuti mutsirize ntchitoyi ndi kutseka bokosi la bokosi
8. Yankho la 8 liyenera kuoneka mu selo C2 chifukwa ili ndilo lotsatira kwambiri kuposa nambala 6.023
9. Mukasindikiza pa selo C2 ntchito yonse = EVEN (A2) ikuwonekera pa bar barolomu pamwamba pa tsamba

Kujambula Fomu Ndi Dongosolo Lodzaza

M'malo mobwezeretsanso zitsanzo zitatuzi, chikho choyamba chingakopedwe mwamsanga pogwiritsira ntchito chodzaza kapena kukopera ndi kusindikiza kuyambira pamene ndondomeko ya ntchito ya EVEN inaloledwa ngati selo lololedwa .

Zotsatira za opaleshoniyi ziyenera kukhala:

• Maselo C3 ndi C5 ayenera kukhala ndi phindu -8 popeza uwu ndi wotsika kwambiri ngakhale wochepa pambuyo pa miyezo -6.023 ndi -7.023;
• Cell C4 iyenera kukhala ndi mtengo wa 8, umene uli wotsatira wapamwamba kwambiri kuposa 7.023.

#VALUE! Kulakwitsa kwa Mtengo

The #VALUE! Ndalama zowonongeka zimabweretsedwa ngati Excel sakudziwa deta yomwe yalembedwa pa chiwerengero cha Namba ngati nambala. Zomwe mungathe kuzifotokoza zingakhale nambala yomwe inalowa ngati deta .