Qhov wikiHow qhia koj yuav siv lub IFERROR ua haujlwm hauv MS Excel. Txoj haujlwm no rov qab tus nqi tshwj xeeb hauv qhov chaw ntawm qhov ua yuam kev hauv tus qauv. Ib txhia ntawm cov mis tsis raug yog #N/A, #DIV/0!, #NULL!, thiab #ROV!
Cov kauj ruam
Txoj Kev 1 ntawm 2: Tiv Thaiv Kev Ua Phem Yav Tom Ntej
Kauj Ruam 1. Nyem rau ntawm tes uas yuav muaj koj cov mis tseem ceeb
Nov yog cov qauv uas koj tab tom sim tswj kev ua yuam kev rau. Qee qhov piv txwv ntawm thaum koj tuaj yeem kwv yees qhov ua yuam kev yog:
- Thaum koj paub qee cov ntaub ntawv siv hauv VLOOKUP cov mis yuav ploj. VLOOKUP yuav rov los #N/A thaum nws tsis tuaj yeem nrhiav tus nqi saib hauv cov kab lus tshwj xeeb.
-
Thaum koj siv cov qauv sib faib thoob plaws cov ntaub ntawv hais qhia, thiab koj paub tias koj yuav muaj qee qhov tseem ceeb ploj hauv cov nyiaj faib. Kev faib tawm los ntawm 0 lossis lub xov tooj ntawm tes dawb paug yuav ua rau #DIV/0!
yuam kev
Kauj Ruam 2. Pib ntaus IFERROR ua haujlwm
Ntaus qhov kos npe sib npaug = ua raws los ntawm IFERROR (.
Cov IFERROR muaj nuj nqi siv 2 kev sib cav: tus nqi los tshuaj xyuas qhov ua yuam kev thiab tus nqi rov qab los ntawm qhov ua yuam kev.
Kauj Ruam 3. Sau tus nqi uas yuav ua rau muaj qhov yuam kev
Qhov no tuaj yeem yog mis, hais txog ntawm tes, lossis qhia tawm.
Cais qhov no los ntawm cov lus qhia tom ntej los ntawm kev ntaus tus lej, tom qab tus nqi
Kauj Ruam 4. Sau tus nqi uas yuav tsum hloov qhov yuam kev
Qhov no tuaj yeem yog cov ntawv, tus lej, lwm tus lej, lossis khoob.
- Txhawm rau siv cov ntawv, nco ntsoov tias koj tso cov lus hais ib ncig ntawm cov ntawv.
- Txhawm rau hloov qhov ua yuam kev nrog lub cell dawb paug, ntaus "" raws li tus nqi no.
Kauj Ruam 5. Xaus koj txoj haujlwm nrog)
Hauv tag nrho, txoj haujlwm yuav tsum zoo li IFERROR (tus nqi, tus nqi_if_error). Qee qhov piv txwv ntawm cov mis no yuav yog:
- IFERROR (VLOOKUP (F1, A: B, 2, FALSE), "ploj lawm") yuav xub sim nrhiav tus nqi hauv F1 hauv kab A thiab xa nws cov nqi sib xws los ntawm kab B. Excel mam li qhia lo lus "ploj lawm" yog tias nws tsis tuaj yeem pom F1 tus nqi hauv kab B, ntau dua #N/A.
-
IFERROR (A1/B1, "") yuav rov qab lub xov tooj ntawm tes tsis txhob siv #DIV/0!
yog tias B1 yog 0 lossis khoob.
Kauj Ruam 6. Ntaus ↵ Sau kom tiav cov mis
Txheeb xyuas tias nws tau xa rov qab qhov tshwm sim uas koj xav tau.
Txoj Kev 2 ntawm 2: Kev Tswj Yooj Yim
Kauj Ruam 1. Nrhiav kom raug hauv koj daim ntawv Excel
Koj tuaj yeem xaiv txhua qhov ua yuam kev ua cov hauv qab no:
- Hauv Tsev tab, click Nrhiav & Xaiv nyob rau hauv Editing seem
- Xaiv Mus rau Tshwj Xeeb….
- Xaiv Cov Qauv, tom qab ntawd khij txhua yam tsuas yog Yooj Yim.
- Nyem OK.
Kauj Ruam 2. Khaws cov ntawv yuam kev
Koj yuav xav hloov xim ntawm tes yog li koj tuaj yeem pom lawv yooj yim ntawm daim ntawv nthuav qhia.
Txhawm rau hloov xim ntawm tes, nyem lub xub xub nyob ib sab ntawm Sau Xim khawm thaum khaws cov xov tooj tseem ceeb. Lub pob no muaj nyob hauv ntu Font hauv Tsev tab. Xaiv xim.
Kauj Ruam 3. Nrhiav qhov yuam kev uas koj xav hloov nrog tus nqi
Qhov no yuav tsis tas yuav yog txhua qhov yuam kev uas koj pom-qee qhov yuam kev yuav tsum tau kho.
Kauj Ruam 4. Nyem ob npaug rau ntawm tes txhawm rau kho cov mis
Lossis koj tuaj yeem nyem lub xovtooj ntawm tes, tom qab ntawv nyem rau hauv kab ntawv mis nyob rau sab saum toj kom kho.
Kauj Ruam 5. Nyem rau koj tus cursor nyob nruab nrab ntawm qhov kos npe sib npaug = thiab pib ntawm cov mis uas twb muaj lawm
Hom IFERROR (.
Kauj Ruam 6. Nyem rau koj tus cursor ntawm qhov kawg ntawm cov mis uas twb muaj lawm
Sau tus lej,.
Kauj Ruam 7. Sau tus nqi uas yuav tsum hloov qhov yuam kev
Qhov no tuaj yeem yog cov ntawv, tus lej, lwm tus lej, lossis khoob.
- Txhawm rau siv cov ntawv, nco ntsoov tias koj tso cov lus hais ib ncig ntawm cov ntawv.
- Txhawm rau hloov qhov ua yuam kev nrog lub cell dawb paug, ntaus "" raws li tus nqi no.
Kauj Ruam 8. Xaus koj txoj haujlwm nrog)
Hauv tag nrho, txoj haujlwm yuav tsum zoo li IFERROR (tus nqi, tus nqi_if_error). Qee qhov piv txwv ntawm cov mis no yuav yog:
- IFERROR (VLOOKUP (C1, A: B, 2, FALSE), "ploj lawm") yuav xub sim nrhiav tus nqi hauv C1 hauv kab A thiab xa nws cov nqi sib xws los ntawm kab B. Excel mam li qhia lo lus "ploj lawm" yog tias nws nrhiav tsis tau C1 tus nqi hauv kab B, ntau dua #N/A.
-
IFERROR (A1/B1, "") yuav rov qab lub xov tooj ntawm tes tsis txhob siv #DIV/0!
yog tias B1 yog 0 lossis khoob.
Kauj Ruam 9. Ntaus ↵ Sau kom tiav cov mis
Txheeb xyuas tias nws tau xa rov qab qhov tshwm sim uas koj xav tau.