Yuav luag tas li, qhov kev ntsuas ntawm cov ntaub ntawv muab tso rau hauv cov ntawv cuam tshuam nrog kev sib piv lawv nrog lwm tus lossis nrog kev siv qhov tseem ceeb. Yog tias koj siv Microsoft Office Excel cov ntawv sau ua haujlwm los ua haujlwm nrog cov ntaub ntawv sau, koj tuaj yeem siv nws cov haujlwm ua hauv kev sib piv. Cov haujlwm yooj yim tshaj plaws ntawm hom no yog "EXACT" thiab "IF".
Nws yog qhov tsim nyog
Tabular editor Microsoft Office Excel 2007 lossis 2010
Cov Lus Qhia
Kauj ruam 1
Siv EXECUTE txoj haujlwm ua kom paub yog qhov tseem ceeb hauv ob lub rooj ntawv nyeem yog tib yam. Piv txwv, yog tias cov nqi sib piv tau tso rau hauv cov hlwb nrog chaw nyob B3 thiab C3, thiab qhov tshwm sim ntawm lawv kev sib piv yuav tsum muaj nyob rau hauv lub cell D3, nyem nws nrog nas thiab mus rau "Formulas" tab hauv Excel menu. Hauv pawg "Function Library" cov lus txib, qhib "Cov Ntawv" nyob rau hauv daim ntawv teev xa khoom thiab xaiv kab "EXACT" hauv nws. Raws li qhov tshwm sim, ib daim ntawv nrog ob daim teb "Text1" thiab "Text2" yuav tshwm rau ntawm qhov screen, hauv lawv txhua tus muab qhov chaw nyob ntawm ib qho ntawm cov sib piv hlwb (B3 thiab C3). Tom qab ntawv nyem rau ntawm OK khawm thiab koj yuav pom cov txiaj ntsig sib piv - ib qho ntawm cov ntawv sau "FALSE" lossis "TRUE".
Kauj ruam 2
Yog tias cov ntawv nyeem "FALSE" lossis "QHOV TSEEB" los ntawm qhov kev sib piv tsis haum rau koj, siv qhov kev ua haujlwm "IF" - nws tso cai rau koj los tsim cov txiaj ntsig uas yuav tsum tau tshwm tawm los ntawm kev ua haujlwm. Txhawm rau muab tus cwj mem nyob rau hauv lub xov tooj ntawm tes xaiv rau tso tawm, qhib lub "Logical" xa tawm cov npe hauv tib pab pawg ntawm "Cov Tsev Qiv Ntawv ntawm cov haujlwm" thiab xaiv cov thawj kab - "IF". Daim foos tso tawm los txhawm rau sau cov lus sib cav yuav muaj peb daim teb. Hauv thawj ib - "Log_Expression" - tsim cov haujlwm sib piv ntawm nws tus kheej. Piv txwv li, txhawm rau nrhiav seb qhov tseem ceeb hauv cov B3 thiab C3 puas zoo ib yam, sau B3 = C3. Hauv thaj chaw "Value_if_true" thiab "Value_if_false", tso cov ntawv cim lossis cov naj npawb uas yuav tsum tau tshwm yog tias qhov sib piv yog zoo lossis tsis zoo. Nyem OK mus ua kom tiav nkag mus ua haujlwm cov lus sib cav.
Kauj ruam 3
Yog tias qhov kev sib piv ua haujlwm xav tau los ua kab los ntawm kab rau ob kab ntawm ib lub rooj, tso ib qho ntawm cov haujlwm uas tau piav qhia saum toj ntawm thawj kab ntawm kab thib peb, thiab tom qab ntawd txuas ntxiv mus rau qhov siab ntawm cov kab ntawv piv. Qhov no tuaj yeem ua tiav, piv txwv li, los ntawm kev ncab mus rau sab hauv qab yog kaum ntawm tes nrog tus qauv - thaum koj tsiv lub pointer nas dua nws, tus cursor dhau los ua ib qho ntxiv dub. Tom qab ntawd xaiv kab ntawv thij peb thiab, ntawm Kev Kawm Ntawv Tsev, nthuav dav Cov Ntawv Xam Xaj los ntawm kab lus hauv cov pab pawg style ntawm cov lus txib. Hauv tshooj "Cell Xaiv Kev Xaiv", xaiv kab "Sib Xws", thiab tom qab ntawd nyem thawj kab ntawm kab ntawv xaiv thiab nias Enter. Ua li no, koj yuav hais meej cov hlwb nrog cov ntsuas sib piv ntawm cov ntaub ntawv sib piv - qhov no yuav pom ntau dua qhov sawv cev cov txiaj ntsig ntawm kev ua haujlwm.
