Ib qho piv txwv ntawm IF THEN nqe lus yog dab tsi?
Ib qho piv txwv ntawm IF THEN nqe lus yog dab tsi?

Video: Ib qho piv txwv ntawm IF THEN nqe lus yog dab tsi?

Video: Ib qho piv txwv ntawm IF THEN nqe lus yog dab tsi?
Video: Qhov Kev Sib Txheeb Ntawm Vajtswv thiab phau Vajluskub Yog Dab Tsi? 2024, Kaum ib hlis
Anonim

Yog - ces nqe lus . Ib qho xwm txheej nqe lus yog cuav yog hypothesis yog qhov tseeb thiab qhov xaus yog cuav. Cov piv txwv saum toj no yuav tsis tseeb yog nws hais tias " yog koj tau qhab nia zoo ces koj yuav tsis tau mus rau hauv ib lub tsev kawm ntawv zoo."

Ib yam li ntawd, ib tug yuav nug, dab tsi yog ib qho piv txwv ntawm cov nqe lus muaj cai?

Kev daws: Hauv Piv txwv 1, p sawv cev rau, "Kuv ua haujlwm hauv kuv tsev," thiab q sawv cev rau "Kuv tau txais kuv cov nyiaj pub dawb." Cov nqe lus p q yog nqe lus hais uas sawv cev "Yog p, ces q." Lus txhais: A xwm txheej , cim los ntawm p q, yog ib qho yog-thaum ntawd nqe lus uas p yog ib qho kev xav thiab q yog qhov xaus.

Tsis tas li ntawd, kuv yuav sau ib nqe lus yog hauv Excel li cas? Siv tus IF function, ib logical functions, xa ib tug nqi yog a mob yog qhov tseeb thiab lwm tus nqi yog nws yog cuav. Rau piv txwv : = IF (A2>B2, "Over Budget", "OK") = IF (A2 = B2, B4-A4, "")

Yog li ntawd, dab tsi yog thawj feem ntawm IF THEN nqe lus?

Lub hypothesis yog qhov ua ntej , los yog " yog ,” ib feem ntawm ib tug conditional nqe lus . Qhov xaus yog qhov thib ob, lossis " ces ,” ib feem ntawm ib tug conditional nqe lus . Qhov xaus yog qhov tshwm sim ntawm ahypothesis.

Koj sau nqe lus li cas?

Hypotheses ua raws li qhov xaus yog hu ua If-then nqe lus los yog a nqe lus hais . A nqe lus hais yog cuav yog hais tias hypothesis muaj tseeb thiab cov lus xaus yog cuav. Cov piv txwv saum toj no yuav tsis raug yog tias nws hais tias "yog tias koj tau qhab nia zoo ces koj yuav tsis tau mus rau hauv ib lub tsev kawm ntawv zoo".

Pom zoo: