Contents
Jiya a gudun marathon 30 Excel yana aiki a cikin kwanaki 30 muna neman dabi'u ta amfani da aikin DUBA SAMA (DUBI). A yau za mu sake amfani da wannan aikin don yin aiki akan kwari.
Za mu sadaukar da ranar 17th na marathon don nazarin aikin KUSKURE. TYPE (KYAUTA NAU'IN). Yana iya gane nau'ikan kurakurai, kuma ku, bi da bi, kuna iya amfani da wannan bayanin don kawar da su.
Don haka, bari mu kalli bayanai da misalan amfani da aikin KUSKURE. TYPE (ERROR TYPE) a cikin Excel. Idan kuna da ƙarin bayani ko misalai, da fatan za a raba su a cikin sharhi.
Aiki 17: ERROR.TYPE
aiki KUSKURE. TYPE (ERROR.TYPE) yana ƙayyade nau'in kuskure ta lamba ko dawowa #AT (#N/A) idan ba a sami kuskure ba.
Ta yaya za a iya amfani da aikin ERROR.TYPE?
Ta hanyar KUSKURE. TYPE (ERROR.TYPE) Kuna iya:
- gano nau'in kuskuren.
- taimaka masu amfani gyara kurakurai da suka faru.
ERROR.TYPE
aiki KUSKURE. TYPE (ERRORTYPE) yana da ma'ana mai zuwa:
ERROR.TYPE(error_val)
ТИП.ОШИБКИ(значение_ошибки)
- kuskure_val (error_value) kuskure iri ɗaya ne da ake buƙatar ganowa.
- lambobin da aikin ya dawo dasu KUSKURE. TYPE (KUSKUREN NAUYIN):
- 1… # NULL! (#EMPTY!)
- 2… # DIV / 0! (#DEL/0!)
- 3… #DARAJAR! (#SO!)
- 4… #REF! (#SSYL!)
- 5… #NAME? (#NAME?)
- 6… # A DAYA! (#NUMBER!)
- 7… #AT (#N/A)
- #AT (#N/A) … kowace ƙima
Tarko ERROR.TYPE
Idan darajar hujja kuskure_val (error_value) ba kuskure bane, sakamakon aiki KUSKURE. TYPE (ERROR.TYPE) zai zama saƙon kuskure #AT (#N/A). Kuna iya guje wa wannan idan kun yi amfani da aikin ISERROR (ISERROR) don bincika kuskure, kamar yadda aka nuna a misali 2.
Misali 1: Ƙayyade nau'in kuskure
Amfani da ayyuka KUSKURE. TYPE (ERROR.TYPE) Kuna iya bincika tantanin halitta don sanin irin kuskuren da ya kunsa. Idan babu kuskure a cikin tantanin halitta, to, maimakon lambar kuskuren lamba, za a dawo da ƙimar #AT (#N/A).
=ERROR.TYPE(B3)
=ТИП.ОШИБКИ(B3)
A cikin wannan misali, tantanin halitta B3 ya ƙunshi #DARAJAR! (#VALUE!), Don haka nau'in kuskuren shine 3.
Misali 2: Taimakawa Masu Amfani da Kurakurai
Ta hanyar haɗawa KUSKURE. TYPE (ERROR TYPE) tare da wasu ayyuka, zaku iya taimakawa masu amfani su gyara kurakurai da suka bayyana a cikin tantanin halitta. A cikin wannan misali, dole ne a shigar da lambobi a cikin sel B3 da C3. Idan an shigar da rubutu, sakamakon a D3 zai zama saƙon kuskure #DARAJAR! (#DARAJAR!). Idan an shigar da sifili a cikin cell C3, sakamakon zai zama saƙon kuskure #DIV/0 (#SASHE/0).
A cikin cell D4, aikin ISERROR (ISERROR) yana bincika kuskure, kuma KUSKURE. TYPE (ERROR.TYPE) yana mayar da lambar wannan kuskuren. Aiki DUBA SAMA (LOOKUP) ya sami saƙon da ya dace a cikin tebur ɗin kuskure tare da alamar yadda ake gyara kuskuren kuma ya nuna shi ga mai amfani.
=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);"")
Anan akwai tebur na wasiƙa tsakanin lambobin kuskuren lamba da saƙonnin da aka nuna: