Imisebenzi engama-30 ye-Excel ezinsukwini ezingama-30: ERROR.TYPE (ERROR.TYPE)

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:

shiya impendulo