Tse ka Hare
Maobane lebelong la marathone 30 Excel e sebetsa ka matsatsi a 30 re ne re batla litekanyetso tse sebelisang ts'ebetso SHEBA HOLIMO (SHEBISO). Kajeno re tla sebelisa ts'ebetso ena hape ho sebetsa ho litšitšili.
Re tla nehelana ka letsatsi la 17th la marathon ho ithuta mosebetsi PHOSO.MOFUTA (MOFUTA.PHOSO). E khona ho lemoha mefuta ea liphoso, 'me uena, u ka sebelisa tlhahisoleseling ena ho li felisa.
Kahoo, a re shebeng tlhahisoleseling le mehlala ea ho sebelisa ts'ebetso PHOSO.MOFUTA (EROR TYPE) ho Excel. Haeba u na le tlhaiso-leseling e eketsehileng kapa mehlala, ka kopo e arolelane maikutlong.
Mosebetsi oa 17: PHOSO.MOFUTA
mosebetsi PHOSO.MOFUTA (ERROR.TYPE) e khetha mofuta oa phoso ka nomoro kapa ho khutlisa #AT (#N/A) haeba ho se phoso e fumanoeng.
Mosebetsi oa ERROR.TYPE o ka sebelisoa joang?
Ka mokhoa oa PHOSO.MOFUTA (ERROR.TYPE) U ka:
- tsebahatsa mofuta wa phoso.
- thusa basebelisi ho lokisa liphoso tse etsahalang.
Syntax ERROR.TYPE
mosebetsi PHOSO.MOFUTA (ERRORTYPE) e na le syntax e latelang:
ERROR.TYPE(error_val)
ТИП.ОШИБКИ(значение_ошибки)
- error_val (error_value) ke eona phoso e lokelang ho tsejoa.
- likhoutu tse khutlisitsoeng ke tšebetso PHOSO.MOFUTA (TYPE.ERROR):
- 1 ... #NTLE! (#HO HLOKA!)
- 2 ... # DIV / 0! (#DEL/0!)
- 3 ... #BOTLALO! (#SO!)
- 4 ... #REF! (#SYL!)
- 5 ... #NAME? (#Lebitso?)
- 6 ... #HO NNGWE! (#NUMBER!)
- 7 ... #AT (#N/A)
- #AT (#N/A) … boleng bofe kapa bofe
Maraba ERROR.TYPE
Haeba boleng ba khang error_val (error_value) ha se phoso, sephetho sa mosebetsi PHOSO.MOFUTA (ERROR.TYPE) e tla ba molaetsa oa phoso #AT (#N/A). U ka qoba sena haeba u sebelisa ts'ebetso KHAHLISO (ISERROR) ho lekola phoso, joalo ka ha ho bontšitsoe mohlaleng oa 2.
Mohlala 1: Ho fumana mofuta oa phoso
Ho sebelisa mesebetsi PHOSO.MOFUTA (ERROR.TYPE) U ka hlahloba sele ho fumana hore na e na le phoso ea mofuta ofe. Haeba ho se na phoso ka seleng, joale ho e-na le khoutu ea phoso ea linomoro, boleng bo tla khutlisetsoa #AT (#N/A).
=ERROR.TYPE(B3)
=ТИП.ОШИБКИ(B3)
Mohlala ona, sele B3 e na le #BOTLALO! (#VALUE!), kahoo mofuta oa phoso ke 3.
Mohlala 2: Ho Thusa Basebedisi ho Sebetsana le Liphoso
Ka ho kopanya PHOSO.MOFUTA (ERROR TYPE) ka mesebetsi e meng, u ka thusa basebelisi ho lokisa liphoso tse hlahang ka har'a sele. Mohlala ona, linomoro li tlameha ho kenngoa liseleng tsa B3 le C3. Haeba mongolo o kentsoe, sephetho ho D3 e tla ba molaetsa oa phoso #BOTLALO! (#BOHLOKO!). Haeba zero e kentsoe seleng ea C3, sephetho e tla ba molaetsa oa phoso #DIV/0 (#KAROLO/0).
Ka seleng ea D4, mosebetsi KHAHLISO (ISERROR) e hlahloba phoso, le PHOSO.MOFUTA (ERROR.TYPE) e khutlisa nomoro ea phoso ena. Mosebetsi SHEBA HOLIMO (LOOKUP) e fumana molaetsa o nepahetseng tafoleng ea khoutu ea phoso e nang le leseli la ho lokisa phoso le ho e bontša mosebelisi.
=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);"")
Mona ke lethathamo la ngollano lipakeng tsa likhoutu tsa liphoso tsa linomoro le melaetsa e bontšitsoeng: