Hauv ntau hom lus programming, "cov lus hais" raug siv los ntsuas tus mob. Microsoft Office Excel cov ntaub ntawv tshaj tawm nws tus kheej muaj cov haujlwm ua haujlwm, uas tuaj yeem hu ua cov lus sib txuas lus yooj yim heev. Hauv nws, cov kab xev ntawm cov tswj hwm txoj cai yog "IF" ua haujlwm.
Tsim nyog
Microsoft Office Excel cov ntawv teev lus tshaj tawm
Cov Lus Qhia
Kauj ruam 1
Xaiv lub cell hauv daim ntawv txheeb uas qhov xwm txheej kuaj mob yuav tsum tau muab tso rau thiab pib Formula Wizard. Qhov no tuaj yeem ua tiav los ntawm txhaj cov cim nyob rau sab laug ntawm daim qauv mauv. Nyob rau hauv lub qhov rai uas qhib, qhib "Qiv" cov npe xaiv thiab xaiv kab "Logical". Cov npe ntawm cov haujlwm yuav tshwm nyob hauv qab cov npe no - xaiv kab “IF” hauv nws, nyem khawm OK thiab Excel yuav qhib daim foos tsim muaj haujlwm. Daim foos ib yam tuaj yeem hu ua lwm txoj hauv kev - hauv "Cov Ntawv Qiv thiab Kev Lom Zem" pawg ntawm cov lus txib ntawm "Cov Qauv" tab, qhib cov "Logical" nco-down sau thiab xaiv cov "IF".
Kauj ruam 2
Hauv daim ntawv "Log_expression", muab cov xwm txheej uas qhov haujlwm no yuav tsum kuaj xyuas. Piv txwv li, yog tias koj xav txheeb xyuas yog tias tus nqi hauv cell A1 tsis zoo, pib los ntawm txhaj rau ntawm lub xovtooj no nrog nas lossis sau nws qhov chaw nyob (A1). Tom qab ntawd ntxiv tus lej qis dua kos npe thiab xoom kom tau txais cov khoom nkag no: A1
Kauj ruam 3
Mus rau lwm daim foos tom ntej - "Value_if_true". Tso tus naj npawb, lo lus, lossis chaw nyob hauv ib lub xov tooj ntawm lub rooj uas lub xov tooj no yuav tsum qhia yog tias muaj mob. Ib lo lus lossis kab lus yuav tsum raug ntaus nkag rau hauv nqe lus, tus lej - tsis muaj cov lus hais, thiab qhov yooj yim tshaj plaws los teeb tsa lub chaw nyob yog nyem rau ntawm nws nrog tus nas pointer. Piv txwv li los ntawm cov kauj ruam dhau los, koj tuaj yeem tso cov ntawv " tus nqi tsis zoo "ntawm no.
Kauj ruam 4
Daim teb tom ntej ntawm daim foos - "Value_if_true" - sau rau qhov zoo ib yam nkaus li yav dhau los, tab sis muab tso rau hauv nws tus nqi uas yuav tsum tau ua kom pom yog tias qhov kev mob tshwj xeeb tsis tau ntsib. Hauv qhov piv txwv tau siv ntawm no, nws yog qhov tsim nyog los muab cov ntawv sau " tus nqi tsis yog tsis zoo ".
Kauj ruam 5
Nyem OK thiab Excel yuav tam sim ntawd kuaj tus mob koj teev thiab qhia qhov tshwm sim. Tom qab ua tiav ntawm lub wizard, piv txwv li siv saum toj no, cov qauv hauv lub xov tooj ntawm tes yuav tsum zoo li no: “= IF (A1
