Ukuhlawula i-AND, OKANYE, kunye nokuba IMISEBENZI e-Excel

Ukusebenzisa imisebenzi enengqiqo ukuvavanya iimeko ezininzi

IMISEBENZI YAKHO, OKANYE kunye ne-IF yileminye imisebenzi eyaziwayo engcono e-Excel.

Yintoni eyenziwa ngu-OR kunye ne-AND Function, njengoko kuboniswe kwimigangatho emibini kunye neyesithathu kumfanekiso ongezantsi uvavanyo lweemeko ezininzi kwaye, kuxhomekeka kukuphi umsebenzi osetyenziswayo, enye okanye yonke imimiselo mayibe yinyani yomsebenzi ukubuyisela impendulo yangempela. Ukuba akunjalo, umsebenzi ubuyisela iFALSE njengexabiso.

Kulo mfanekiso ungezantsi, iimeko ezintathu zivavanywa ngamafomula kwimigangatho yesibini neyesithathu:

• Ngaba ixabiso kwi-cell A2 ngaphantsi kwama-50;
• Ngaba ixabiso kwi-cell A3 alinganayo 75;
• Ngaba ixabiso kwi-cell A4 likhulu kunokuba lilingana no-100.

Ukuba umsebenzi we- OR , ukuba enye yeemeko ziyinyani, umsebenzi ubuyisela ixabiso leYENYE kwiseli yeB2.

KOMSEBENZI NOMSEBENZI, zonke iimeko ezintathu mazibe yinyani kumsebenzi ukubuyisela ixabiso le-TRUE kwi-cell B3.

Ukudibanisa i-OR kunye ne-IF, okanye i-AND ne-IF Imisebenzi kwi-Excel

Ngoko unemiSebenzi ye-OR kunye nemisebenzi. Ngoku kuthweni?

Ukongeza kwi-IF Function

Xa enye yale miba mibili idibaniswe nomsebenzi we-IF, ifom ephumela ekubeni inamandla amakhulu.

Imisebenzi yokuhlamba kwi-Excel ibhekisela ekufakeni umsebenzi omnye ngaphakathi kwelinye. Umsebenzi odibeneyo usebenza njengenye yeengxoxo eziphambili zomsebenzi.

Kulo mfanekiso ungentla, imigqa emine ukuya kwi sixhenxe iqulethe iifomula apho umsebenzi we-AND okanye wesi-OR uhlala ngaphakathi kwi-IF umsebenzi.

Kuzo zonke imizekelo, umsebenzi odibeneyo usebenza njengomsebenzi we-IF wokuqala okanye ingxoxo yeLogical_test .

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

= IF (kunye (A2 <50, A3 <> 75, A4> = 100), NGAMANYE (), 1000)

Ukutshintsha i-Formula Output

Kuzo zonke iifomula kwimigangatho emine ukuya kwi sixhenxe, imisebenzi ye-AND kunye ne-OR zifana nabalingani babo kwimigangatho emibini neyesithathu ekuvavanyeni idatha kwiiseli ze-A2 ukuya kwi-A4 ukuze zibone ukuba zihlangabezana nemeko efunekayo.

Umsebenzi we-IF usetyenziswe ukulawula imveliso yefomyula ngokubhekisele kwizinto ezifakwe kwisigqibo sesibini kunye nesithathu.

Esi siphumo sinoku:

• Umbhalo - umqolo wesine;
• Inani elinesibini kumqolo;
• Isiphumo esivela kumsebenzi okanye umhlathi-umqolo wesihlanu (umsebenzi we-TODAY) kunye nomqolo wesithandathu;
• Isalathisi esingenanto engumqolo wesixhenxe (iseli B7).

Kwimeko ye-IF / AND formula kwifayile ye-B5, kuba akubona zonke iiseli ezintathu kwi-A2 ukuya ku-A4 ziyi nyaniso-ixabiso kwi-cell A4 ayilona likhulu kunokuba lilingana no-100-UMSEBENZI we-AND u buyisela ixabiso le-FALSE.

Umsebenzi we-IF usebenzisa le xabiso kwaye ubuyisela i- Value_if_false argument - umhla okhoyo wangoku owanikwa ngu -TODAY umsebenzi .

Ngakolunye uhlangothi, ifom ye-IF / OR kumqolo we-4 ubuyisela ingxelo yesitatimende Idatha echanekileyo ngenxa yokuba:

1. Ixabiso le-OR libuyile inani le-TRUE - inani kwi-cell A3 alilingani 75.
2. Umsebenzi we-IF wasebenzisa le miphumo ukubuyisela i- Value_if_false argument yayo: Idatha ilungile .

Ukubhala i-Excel IF / OR Formula

Amanyathelo angezantsi ajonga indlela yokufaka ifom ye-IF / OR esele kwiseli B4 kumfanekiso ongentla. Amanyathelo afanayo angasetyenziselwa ukungena nayiphi na iFOM ifomula kumzekelo.

Nangona kunokwenzeka ukuba uthayiphe kuphela ifom epheleleyo ngesandla,

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

Abantu abaninzi bakuthola kulula ukusebenzisa ibhokisi yencoko yencoko yomsebenzi we-IF ukufaka ifomu kunye neengxoxo njengoko ibhokisi yencoko yababini iyayinyamekela i-syntax njengabahluli be-comma phakathi kweengxabano kunye nokufakwa kwamagama angqonge kwiimpawu zokucaphulwa.

Amanyathelo asetyenziswa ukufaka ifom ye-IF / OR kwiseli yeB4 yile:

1. Cofa kwifowuni B4 ukwenza iseli esebenzayo .
2. Cofa kwiThebhu yefomula yerbhoni .
3. Cofa kwi icon yeLogical ukuvula uluhlu lwehla phantsi.
4. Nqakraza Ukuba kuluhlu ukuvula ibhokisi yencoko yencoko ye-IF.
5. Cofa umgca weLogical_test kwibhokisi yencoko.
6. Faka umsebenzi opheleleyo: OKANYE (A2 <50, A3 <> 75, A4> = 100) kumgca weLogical_test usebenzisa ikhonkco zeeferensi zeeferensi ukuba zifunwa.
7. Cofa kwi- Value_if_kona umgca kwibhokisi yencoko.
8. Thayipha kwisicatshulwa I- Data echanekileyo (akukho maxwebhu okucaphuna afunekayo).
9. Cofa kwi- Value_if_false umgca kwibhokisi yencoko.
10. Thayipha kwitekisi I mpazamo yedatha.
11. Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela.
12. Njengoko sele sele sichazwe ngasentla, umhlathi kufuneka ubonise ixabiso le- Value_if_krue of Data Correct.
13. Xa ucofa kwi- cell B4 , umsebenzi opheleleyo
    = IF (OKANYE (A2 <50, A3 <> 75, A4> = 100), "Idatha echanekileyo", "Iphutha Ledatha") ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.