Lub hom phiaj ntawm lub laj thawj muaj nuj nqi "yog" nyob rau hauv cov ntawv tshaj xo Microsoft Office Excel yog los tshawb xyuas qhov tseeb ntawm qhov hais tawm dhau mus rau nws. Nyob ntawm qhov txiaj ntsig ntawm qhov kev kuaj xyuas no, qhov haujlwm rov qab ib qho ntawm ob qhov nuj nqis dhau rau nws rau qhov no. Txhua ntawm peb qhov tsis dhau - qhov xwm txheej thiab ob qho txiaj ntsig rov qab - kuj tseem tuaj yeem yog qhov kev sib piv ua haujlwm, tso cai rau qee qhov kev sib cav.
Tsim nyog
Yooj yim Excel lub zog txawj
Cov Lus Qhia
Kauj ruam 1
Siv cov boolean thiab cov neeg teb xov tooj kom nce cov lus sib cav sib piv los ntawm kev siv tus if. Nws yuav tso cai rau koj kom siv ntau qhov kev sib piv hauv cov xwm txheej thaum uas nws tsim nyog tias txhua qhov kev sib piv hauv cov lus sib cav muaj tseeb. Piv txwv, yog tias txoj haujlwm no yuav tsum rov qab ua ib qho, muab tias tus nqi hauv cell A1 yog qhov ntau dua tus nqi hauv cell A5, thiab tus nqi ntawm B1 yog tib yam li tus nqi ntawm B3, tom qab ntawv "yog tias" muaj nuj nqi tuaj yeem sau zoo li qhov no: YOG (THIAB (A1> A5; B1 = B3); 1; 2). Tus naj npawb ntawm kev sib cav mus rau "thiab" muaj nuj nqi tsis tuaj yeem yuav ntau dua 30, tab sis txhua tus ntawm lawv tus kheej tuaj yeem muaj qhov "thiab" ua haujlwm, yog li koj muaj txoj hauv kev los tso cov roj hmab zes los ntawm cov haujlwm ntawm ib qho kev tsim nyog.
Kauj ruam 2
Qee zaum, hloov qhov xwm txheej tsim nyog, nws yog qhov tsim nyog yuav tau kuaj xyuas qhov muaj mob txaus. Hauv cov xwm txheej zoo li no, hloov qhov "thiab" muaj nuj nqi, nthuav dav tus naj npawb ntawm kev sib cav uas siv "lossis" ua haujlwm. Cia hais tias koj xav tau yog tias kev ua haujlwm rov qab ib qho thaum twg tus nqi hauv cell A1 ntau dua tus nqi hauv cell A5, lossis B1 yog tib yam li B3, lossis A4 yog tus lej tsis zoo. Yog tias tsis muaj ib qho ntawm cov mob uas tau ntsib, tom qab ua haujlwm yuav tsum rov qab xoom. Xws li kev tsim ntawm peb qhov sib piv thiab ob rov qab los sib cav ntawm "yog" muaj nuj nqi tuaj yeem sau zoo li no: IF (LOSSIS (A1> A5; B1 = B3; A4
Kauj ruam 3
Ua ke nrog "thiab", "lossis" thiab "yog tias" ua haujlwm ntawm ntau lub zes sib txawv kom tau txais cov txiaj ntsig zoo rau kev sib piv cov naj npawb ntawm cov lus xav kom muaj. Piv txwv li: IF (LOS YOG (A1> A5; IF (THIAB (A7> A5; B1)
Kauj ruam 4
Siv qhov thib ob thiab thib peb yog tias kev sib cav (rov qab qhov tseem ceeb) kom nce tus naj npawb ntawm cov tsis sib xws. Txhua ntawm lawv tuaj yeem muaj xya theem ntawm zes nrog "thiab", "lossis" thiab "yog tias" ua haujlwm. Nyob rau tib lub sijhawm, tsis txhob hnov qab tias cov haujlwm sib piv uas koj tso rau hauv kev sib cav zaum ob yuav raug kuaj xyuas tsuas yog kev sib piv hauv thawj "yog tias" sib cav rov tus nqi "muaj tseeb". Txwv tsis pub, cov haujlwm tau sau rau hauv txoj haujlwm ntawm kev sib cav thib peb yuav raug kuaj xyuas.
