Ukuhlaziya i-AND, OR, kanye ne-IF Imisebenzi e-Excel

Ukusebenzisa imisebenzi enengqondo ukuhlola izimo eziningi

Imisebenzi ye-AND,, OR kanye ne-IF ingenye yemisebenzi ehlakaniphile eyaziwa nge-Excel.

Okushiwo yi-OR noma i-AND Function, njengoba kuboniswe emigqeni emibili nantathu esithombeni esingezansi yizimo eziningi zokuhlola futhi, kuye ngokuthi iyiphi umsebenzi osetshenzisiwe, eyodwa noma yonke imibandela kufanele ibe yilelo msebenzi ukubuyisela impendulo ye-TRUE. Uma kungenjalo, lo msebenzi ubuyisela i-FALSE njengenani.

Esikhathini esingezansi, izimo ezintathu zivivinywa ngamafomula emigqeni emibili nantathu:

• Ingabe inani eliseli cell A2 lingaphansi kuka-50;
• Ingabe inani eliseli cell A3 alilingani 75;
• Ingabe inani eliselikanini le-A4 likhulu kunaleyo noma lilingana no-100.

Ngomsebenzi we- OR , uma enye yalezi zimo kuyiqiniso, umsebenzi ubuyisela inani le-TRUE kuseli B2.

Ku-AND AND Function, zonke izimo ezintathu kufanele zibe yiqiniso kulo msebenzi ukubuyisela inani le-TRUE kuseli B3.

Ukuhlanganisa i-OR ne-IF, noma imisebenzi ye-AND AND IF ku-Excel

Ngakho unayo imisebenzi ye-OR kanye ne-AND. Manje?

Ukwengeza emsebenzini we-IF

Uma enye yalezi zinto ezimbili ihlanganiswe nomsebenzi we-IF, ifomula eliholayo linamakhono amakhulu kakhulu.

Imisebenzi yokudoba ku-Excel ibhekisela kokufaka umsebenzi owodwa ngaphakathi komunye. Umsebenzi ocebile usebenza njengesinye sezimpendulo zomsebenzi oyinhloko.

Emfanekisweni ngenhla, imigqa emine kuya kweyisikhombisa iqukethe amafomula lapho umsebenzi we-AND noma u-OR unamathele ngaphakathi komsebenzi we-IF.

Kuzo zonke izibonelo, umsebenzi ocebile usebenza njengengxabano yokuqala ye-IF noma i- Logical_test .

= IF (OR (A2 <50, A3 <> 75, A4> = 100), "Idatha efanele", "Iphutha Ledatha")

= IF (NOMA (A2 <50, A3 <> 75, A4> = 100), NAMUHLA (), 1000)

Ukushintsha Ukukhishwa kweFormula

Kuzo zonke amafomula emigqeni ezine kuya kweyisikhombisa, imisebenzi ye-AND ne-OR iyafana nabalingani babo emigqeni emibili nantathu lapho behlola idatha emafenjini A2 kuya ku-A4 ukuze abone ukuthi ihlangabezana nesimo esidingekayo.

Umsebenzi we-IF usetshenziselwa ukulawula ukukhishwa kwefomula ngokusekelwe kulokho okufakwe emibhalweni yesibili neyesithathu.

Lokhu okukhiphayo kungaba:

• Umbhalo - umugqa ezine;
• Inombolo - irowu emihlanu;
• Ukukhishwa okuvela emsebenzini noma ifomula - irowu emihlanu (NOMSEBENZI umsebenzi) nomugqa wesithupha;
• Iseli elingenalutho - irowu eliyisikhombisa (iseli B7).

Endabeni yefomu ye-IF / ANDOM e-cell B5, ngoba akulona wonke amaseli amathathu ku-A2 kuya ku-A4 ayiqiniso-ukubaluleka esitokisini se-A4 akukhulu kunalokho noma kulingana no-100-umsebenzi we-AND ubuyisa inani le-FALSE.

Umsebenzi we-IF usebenzisa le nzuzo futhi ubuyisela i- Value_if_false ingxabano - usuku lwangoku olunikezwa umsebenzi we-TODAY .

Ngakolunye uhlangothi, ifomula le-IF / OR emgqeni amane libuyisela isitatimende sombhalo Idatha yokulungisa ngoba:

1. Inani elingu-OR libuyile inani le-TRUE - inani eliseli cell A3 alilingani 75.
2. Umsebenzi we-IF wabe esebenzisa lo mphumela ukubuyisela i- Value_if_false argument yayo: Idatha Yalungile .

Ukubhala i-Excel IF / OR Formula

Izinyathelo ezingezansi zihlanganisa indlela yokufaka ifomula le-IF / OR elisesitokisini B4 esithombeni ngenhla. Izinyathelo ezifanayo zingasetshenziselwa ukungena noma yikuphi amafomula e-IF kusibonelo.

Yize kungenzeka ukuthi uthayiphe ifomula ephelele ngesandla,

= IF (OR (A2 <50, A3 <> 75, A4> = 100), "Idatha efanele", "Iphutha Ledatha")

abantu abaningi bakuthola kulula ukusebenzisa ibhokisi lebhokisi lengxoxo yomsebenzi we-IF ukungena ifomula nezimpikiswano njengoba ibhokisi lengxoxo lizinakekela i-syntax njengabahlukanisi be-comma phakathi kwama-arguments kanye nokufakwa kombhalo okuzungezile kumamaki okucaphuna.

Izinyathelo ezisetshenziselwa ukungena kwifomula ye-IF / OR kuseli b4 yilezi:

1. Chofoza kuseli B4 ukuze wenze iseli esebenzayo .
2. Chofoza ithebhu yefomu yebhebhoni .
3. Chofoza isithonjana se- Logical ukuvula uhlu oluhlehlisiwe lomsebenzi.
4. Chofoza u- IF ohlwini ukuze uvule ibhokisi lebhokisi lebhodi le-IF.
5. Chofoza umugqa we- Logical_test ebhokisini lengxoxo.
6. Faka umsebenzi ophelele NOMA : (A2 <50, A3 <> 75, A4> = 100) kumugqa we-Logical_test usebenzisa ukukhomba izinkomba zeseli uma zifunwa.
7. Chofoza umugqa we- value_if_krue ebhokisini lengxoxo.
8. Thayipha ku- Idatha Idatha Ekulungile (akukho ama-quotation marks adingekayo).
9. Chofoza ku- Value_if_false line ebhokisini lengxoxo.
10. Thayipha umbhalo Iphutha Ledatha.
11. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela.
12. Njengoba sekukhulunywe ngaye ngenhla, ifomula kufanele ibonise i- Value_if_yiqiniso lokuphikisana kweDatha ekulungisiwe .
13. Uma uchofoza ku- cell B4 , umsebenzi ophelele
    = IF (OR (A2 <50, A3 <> 75, A4> = 100), "Idatha eqondisiwe", "Iphutha Ledatha") livela kubha yefomula ngaphezulu kwephepha lokusebenzela.