Okuqukethwe
Izolo kumarathon 30 Excel isebenza ngezinsuku ezingama-30 besibheka amanani sisebenzisa umsebenzi BHEKA (BUKA). Namuhla sizosebenzisa lo msebenzi futhi ukuze sisebenze kumaphutha.
Sizonikela ngosuku lwe-17 lwemarathon ekucwaningeni komsebenzi ERROR.TYPE (TYPE.ERROR). Iyakwazi ukubona izinhlobo zamaphutha, futhi nawe, ungasebenzisa lolu lwazi ukuze uwaqede.
Ngakho-ke, ake sibheke ulwazi nezibonelo zokusebenzisa umsebenzi ERROR.TYPE (UHLOBO LWEPHUTHA) ku-Excel. Uma unolwazi olwengeziwe noma izibonelo, sicela wabelane ngazo kumazwana.
Umsebenzi 17: IPHUTHA.TYPE
Umsebenzi ERROR.TYPE (ERROR.TYPE) inquma uhlobo lwephutha ngenombolo noma ukubuyisela #AT (#N/A) uma lingekho iphutha elitholakele.
Umsebenzi we-ERROR.TYPE ungasetshenziswa kanjani?
Ngokusebenzisa ERROR.TYPE (ERROR.TYPE) Ungakwazi:
- khomba uhlobo lwephutha.
- siza abasebenzisi ukulungisa amaphutha enzekayo.
I-Syntax ERROR.TYPE
Umsebenzi ERROR.TYPE (ERRORTYPE) ine-syntax elandelayo:
ERROR.TYPE(error_val)
ТИП.ОШИБКИ(значение_ошибки)
- iphutha_val (i-error_value) iphutha elifanayo elidinga ukukhonjwa.
- amakhodi abuyiswe umsebenzi ERROR.TYPE (TYPE.ERROR):
- 1… #NULL! (#AKULULA!)
- 2… # DIV / 0! (#DEL/0!)
- 3… #INANI! (#SO!)
- 4… #REF! (#SYL!)
- 5… # IGAMA (#NAME?)
- 6… #KUNYE! (#NUMBER!)
- 7… #AT (#N/A)
- #AT (#N/A) … noma yiliphi elinye inani
Izicupho ERROR.TYPE
Uma inani lempikiswano iphutha_val (i-error_value) akulona iphutha, umphumela womsebenzi ERROR.TYPE (ERROR.TYPE) kuzoba umlayezo wephutha #AT (#N/A). Ungakugwema lokhu uma usebenzisa umsebenzi ISERROR (ISERROR) ukuhlola iphutha, njengoba kuboniswe esibonelweni sesi-2.
Isibonelo sokuqala: Ukunquma uhlobo lwephutha
Ukusebenzisa imisebenzi ERROR.TYPE (ERROR.TYPE) Ungahlola iseli ukuze uthole ukuthi liqukethe luphi uhlobo lwephutha. Uma lingekho iphutha kuseli, esikhundleni sekhodi yephutha yenombolo, inani lizobuyiswa #AT (#N/A).
=ERROR.TYPE(B3)
=ТИП.ОШИБКИ(B3)
Kulesi sibonelo, iseli B3 liqukethe #INANI! (#INANI!), ngakho uhlobo lwephutha ngu-3.
Isibonelo sesi-2: Ukusiza Abasebenzisi Babhekane Namaphutha
Ngokuhlanganisa ERROR.TYPE (I-ERROR TYPE) neminye imisebenzi, ungasiza abasebenzisi balungise amaphutha avela kuseli. Kulesi sibonelo, izinombolo kufanele zifakwe kumaseli B3 no-C3. Uma umbhalo ufakiwe, umphumela ku-D3 uzoba umlayezo wephutha #INANI! (#INANI!). Uma u-zero efakwe kuseli C3, umphumela uzoba umlayezo wephutha #DIV/0 (#ISIGABA/0).
Kuseli D4, umsebenzi ISERROR (ISERROR) ihlola iphutha, futhi ERROR.TYPE (ERROR.TYPE) ibuyisela inombolo yaleli phutha. Umsebenzi BHEKA (I-LOOKUP) ithola umlayezo ofanelekile kuthebula lekhodi yephutha onophawu lokuthi ulilungisa kanjani iphutha bese ulibonisa kumsebenzisi.
=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);"")
Nali ithebula lokuxhumana phakathi kwamakhodi ezinombolo zamaphutha nemilayezo ebonisiwe: