01 ya 01
Ntchito Excel MID ndi MIDB
Pamene malemba amalembedwa kapena kutumizidwa ku Excel, malemba osokonezeka omwe nthawi zina amawaphatikiza ndi deta yabwino.
Kapena, pali nthawi pamene mbali yokha ya malembawo mu selo ikufunika - monga dzina la munthu koma osati dzina lomaliza.
Pazochitika monga izi, Excel ili ndi ntchito zingapo zomwe zingagwiritsidwe ntchito kuchotsa deta zosayenera kuchokera kwa ena onse.
Ntchito yomwe mumagwiritsa ntchito imadalira kumene deta yabwino ilipo pafupi ndi zida zosafunikira mu selo.
- Ngati deta yabwino, kapena pambali kuti ikhale yosungidwa, ili kumbali yolondola ya deta, gwiritsani ntchito LOWANI ntchito kuti muchotse.
- Ngati chodutsa kumbali ya kumanzere kwa deta, gwiritsani ntchito LEFT ntchito kuti muichotse.
- Ngati cholowacho chiri ndi zilembo zosafunikira ku mbali zonsezo, gwiritsani ntchito MID kapena MIDB ntchito kuti muchotse.
MID ndi vs MIDB
Ntchito za MID ndi MIDB zimasiyanasiyana ndizinenero zomwe zimathandizira.
MID ndizo zinenero zomwe zimagwiritsidwa ntchito ndi khalidwe limodzi lokha- gululi limaphatikizapo zinenero zambiri monga Chingerezi ndi zinenero zonse za ku Ulaya.
MIDB ndizo zinenero zomwe zimagwiritsidwa ntchito kawiri kawiri - zimaphatikizapo Chijapani, Chitchaina (Chosavuta), Chine (Chikhalidwe), ndi Chi Korea.
Msonkhano wa MID ndi MIDB Syntax ndi Arguments
Mu Excel, syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakita, ndi zifukwa .
Syntax ya MID ikugwira ntchito ndi:
= MIDI (Malemba, Start_num, Num_chars)
Chidule cha ntchito ya MIDB ndi:
= MIDB (Text, Start_num, Num_bytes)
Zokambirana izi zikuwuza Excel
- Kodi ndi deta iti imene iyenera kugwiritsidwa ntchito pa ntchitoyi;
- malo oyambira pa deta yabwino kapena cholowera mmalo chomwe chiyenera kutengedwa;
- kutalika kwa mmbuyo.
Malembo - (oyenerera MID ndi MIDB ntchito) chingwe chokhala ndi deta yomwe mukufuna
- kukangana kumeneku kungakhale chingwe chenichenicho kapena selo lolondola pa malo a deta muzenera - mizere 2 ndi 3 mu chithunzi pamwambapa.
Yambani_num - (yofunikira kwa MID ndi MIDB ntchito) imatanthawuza khalidwe loyamba kuchokera kumanzere kwa mmbuyo kuti lisungidwe.
Num_chars - (yofunikira kwa MID ntchito) imatanthauzira chiwerengero cha zilembo kumanja kwa Start_num kuti zisungidwe.
Num_bytes (yofunikira ku ntchito ya MIDB ) imatanthauzira chiwerengero cha zilembo - mu byte - kumanja kwa Qur'an_kuyenera kusungidwa.
Mfundo:
Ngati Start_num ndi yayikulu kuposa kutalika kwalemba chingwe, MID / MIDB imabweretseratu selo lopanda kanthu - mzere 4 wa fanolo, kumene Start_num ndi ofanana ndi 14, ndipo chingwechi ndizithunzi 13 zokha.
Ngati Start_num ili osachepera 1 kapena Num_chars / Num_bytes ndizomwe MID / MIDB ntchito imabwerera #VALUE! Chosowa cholakwika - mzere wachisanu ndi chimodzi cha chithunzi, kumene Start_num ndi ofanana ndi -1.
Ngati Num_chars / Num_bytes ikukamba selo lopanda kanthu kapena layikidwa ku zero, MID / MIDB imabweretseratu chopanda kanthu - mzere 7 wa chithunzicho, kumene Num_chars amawonetsera selo lopanda kanthu B13.
Mphindi Ntchito ya MID - Sakanizani Uthenga Wabwino kuchokera ku Zoipa
Chitsanzo pa chithunzi pamwambapa chikusonyeza njira zingapo zomwe mungagwiritsire ntchito MID ntchito kuti muchotse nambala yeniyeni ya malemba kuchokera pazithunzithunzi zolemba, kuphatikizapo kulowetsa deta mwachindunji monga zifukwa za ntchito - mzere 2 - ndikulowetseramo zigawo zitatu zotsutsana - mzere 5.
Popeza kuti ndi bwino kuti mulowetse zifukwa zamagulu m'malo mndondomeko yeniyeni, zomwe zili pansipa, ndizolemba ndondomeko zomwe zimagwiritsidwa ntchito polowera MID komanso ntchito zake mu selo C5.
Bokosi Lokambirana la MID Function
Zosankha zogwira ntchito ndi zifukwa zake mu selo C5 zikuphatikizapo:
- Kujambula ntchito yonse: = MID (A3, B11, B12) mu selo C5.
- Kusankha ntchito ndi zifukwa pogwiritsa ntchito bokosi la bokosi la ntchito
Kugwiritsira ntchito bokosilo kuti mulowetse ntchito nthawi zambiri kumachepetsanso ntchito monga bokosi lamasewera limagwiritsira ntchito mawu ogwira ntchito - kulowetsa dzina la ntchito, ogawa makasitomala, ndi mabotolo m'malo oyenera ndi ochuluka.
Kuwonetsera pa Mafotokozedwe a Cell
Ziribe kanthu kuti mungasankhe bwanji kulowa ntchitoyi mu selo lamasewero, ndibwino kuti mugwiritse ntchito mfundo ndikusindikiza kuti mulowetse zolemba zonse zomwe zimagwiritsidwa ntchito ngati zifukwa zochepetsera mwayi wa zolakwika zomwe zimapangidwira pakulemba selo lolakwika.
Pogwiritsa ntchito Bokosi la Dialog la MID Function
- Dinani pa selo C1 kuti likhale selo yogwira ntchito - izi ndi zomwe zotsatira za ntchitoyi zidzawonetsedwa;
- Dinani pa Fomu tab ya menyu yowonongeka;
- Sankhani Mawu kuchokera ku kaboni kuti mutsegule ntchito yolemba pansi;
- Dinani pa MID mu mndandanda kuti mubweretse bokosi lazokambirana;
- Mu bokosi la bokosi, dinani pa Text line mu dialog box;
- Dinani pa selo A5 mu tsamba la ntchito kuti mulowetse selo ili ngati Text argument;
- Dinani pa Start_num line
- Dinani pa selo B11 mu tsamba lothandizira kuti mulowetse selo ili;
- Dinani pa Num_chars line;
- Dinani pa selo B12 mu tsamba lokuthandizani kuti mulowetse selo ili;
- Dinani OK kuti mutsirize ntchitoyi ndi kutseka bokosi la dialog;
- Chochotsedwera chojambula chamtundu # 6 chiyenera kuoneka mu selo C5;
- Mukasindikiza pa selo C5 ntchito yonse = MIDI (A3, B11, B12) ikuwonekera pa bar barolomu pamwamba pa tsamba.
Kuchokera Nambala ndi MID Function
Monga momwe tawonetsera mu mzere wachisanu ndi chitatu chachitsanzo pamwambapa, MID yomasulira ingagwiritsidwe ntchito kuchotsa kachigawo kakang'ono ka deta yamtundu kuchokera ku nambala yambiri pogwiritsa ntchito ndondomeko zotchulidwa pamwambapa.
Vuto lokha ndiloti deta yochotsedwa imasinthidwa ndipo sangagwiritsidwe ntchito pakuwerengera ntchito zina - monga SUM ndi AVERAGE ntchito.
Njira imodzi yozungulira vuto ili ndigwiritsira ntchito VALUE ntchito kuti mutembenuzire malemba kukhala nambala monga momwe tawonedwera mzere 9 pamwambapa:
= VALUE (MID (A8,5,3))
Njira yachiwiri ndigwiritsira ntchito phala lapadera kutembenuza malemba ku manambala .