Zamkatimu
Dzulo pa marathon 30 Excel imagwira ntchito m'masiku 30 tinali kuyang'ana zofunikira pogwiritsa ntchito ntchitoyi YANG'ANANI (KUONA). Lero tigwiritsanso ntchito ntchitoyi kuti tigwirenso nsikidzi.
Tidzapereka tsiku la 17 la marathon kuti tiphunzire za ntchitoyi ERROR.TYPE (TYPE.ERROR). Imatha kuzindikira mitundu ya zolakwika, ndipo inunso mutha kugwiritsa ntchito chidziwitsochi kuti muchotse.
Chifukwa chake, tiyeni tiwone zambiri ndi zitsanzo zogwiritsa ntchito ntchitoyi ERROR.TYPE (TYPE YOPHUNZITSA) mu Excel. Ngati muli ndi zina zowonjezera kapena zitsanzo, chonde gawanani nawo mu ndemanga.
Ntchito 17: ERROR.TYPE
ntchito ERROR.TYPE (ERROR.TYPE) imatsimikizira mtundu wa cholakwika ndi nambala kapena zobweza #AT (#N/A) ngati palibe cholakwika chomwe chapezeka.
Kodi ERROR.TYPE ingagwiritsidwe ntchito bwanji?
Mwa njira ERROR.TYPE (ERROR.TYPE) Mutha:
- zindikirani mtundu wa cholakwika.
- thandizani ogwiritsa ntchito kukonza zolakwika zomwe zimachitika.
Syntax ERROR.TYPE
ntchito ERROR.TYPE (ERRORTYPE) ili ndi mawu awa:
ERROR.TYPE(error_val)
ТИП.ОШИБКИ(значение_ошибки)
- error_val (error_value) ndiye cholakwika chomwe chikuyenera kudziwika.
- ma code omwe abwezedwa ndi ntchitoyi ERROR.TYPE (TYPE.ERROR):
- khumi ndi zisanu… #NULU! (# ZOCHITA!)
- khumi ndi zisanu… #DIV/0! (#DEL/0!)
- khumi ndi zisanu… #VALUE! (#KODI!)
- khumi ndi zisanu… #REF! (#SYL!)
- khumi ndi zisanu… #NAME (#NAME?)
- khumi ndi zisanu… #CHIMWEMWE! (#NUMBER!)
- khumi ndi zisanu… #AT (#N / A)
- #AT (#N/A) … mtengo wina uliwonse
Misampha ERROR.TYPE
Ngati mtengo wa mkangano error_val (error_value) si cholakwika, chifukwa cha ntchito ERROR.TYPE (ERROR.TYPE) ukhala uthenga wolakwika #AT (#N / A). Mutha kupewa izi ngati mutagwiritsa ntchito ntchitoyi ISERROR (ISERROR) kuti muwone cholakwika, monga tawonera mu chitsanzo 2.
Chitsanzo 1: Kudziwa mtundu wa zolakwika
Kugwiritsa ntchito ERROR.TYPE (ERROR.TYPE) Mukhoza kuyang'ana selo kuti mudziwe mtundu wa zolakwika zomwe ili nazo. Ngati palibe cholakwika mu selo, ndiye kuti m'malo mwa nambala yolakwika, mtengowo udzabwezeredwa #AT (#N / A).
=ERROR.TYPE(B3)
=ТИП.ОШИБКИ(B3)
Mu chitsanzo ichi, cell B3 ili #VALUE! (#VALUE!), ndiye mtundu wa zolakwika ndi 3.
Chitsanzo 2: Kuthandiza Ogwiritsa Ntchito Kuthana ndi Zolakwa
Mwa kuphatikiza ERROR.TYPE (ERROR TYPE) ndi ntchito zina, mutha kuthandiza ogwiritsa ntchito kukonza zolakwika zomwe zimawonekera mu cell. Mu chitsanzo ichi, manambala ayenera kulowetsedwa mu maselo B3 ndi C3. Ngati malemba alowetsedwa, zotsatira za D3 zidzakhala uthenga wolakwika #VALUE! (#VALUE!). Ngati zero walowa mu selo C3, zotsatira zake zidzakhala uthenga wolakwika #DIV/0 (#GAWO/0).
Mu cell D4, ntchito ISERROR (ISERROR) imayang'ana zolakwika, ndi ERROR.TYPE (ERROR.TYPE) imabweretsanso nambala ya cholakwika ichi. Ntchito YANG'ANANI (LOOKUP) imapeza uthenga woyenerera patebulo lazolakwika ndi malingaliro amomwe mungakonzere cholakwikacho ndikuchiwonetsa kwa wogwiritsa ntchito.
=IF(ISERROR(D3),LOOKUP(ERROR.TYPE(D3),$B$9:$B$15,$D$9:$D$15),"")
=ЕСЛИ(ЕОШИБКА(D3);ПРОСМОТР(ТИП.ОШИБКИ(D3);$B$9:$B$15;$D$9:$D$15);"")
Nayi mndandanda wamakalata pakati pa manambala olakwika ndi mauthenga owonetsedwa: