Amfani da ayyuka masu mahimmanci don gwada hanyoyin da yawa
Ayyukan DA, OR da kuma IF sune wasu ayyuka na mahimmanci na Excel.
Abin da OR da DA Sakamakon yi, kamar yadda aka nuna a cikin layuka biyu da uku a cikin hoton da ke ƙasa suna jarraba yanayi da yawa, kuma, dangane da aikin da aka yi amfani da su, ɗaya ko duk yanayi dole ne ya zama gaskiya ga aikin don dawo da amsa mai ƙarfi. Idan ba haka ba, aikin zai dawo FALSE a matsayin darajar.
A cikin hoton da ke ƙasa, an gwada yanayi uku ta hanyar dabarar a layuka biyu da uku:
- Shin darajar salula A2 kasa da 50;
- Shin darajar a cell A3 ba daidai ba 75;
- Shin darajan tantanin halitta A4 ya fi girma ko kuma daidai da 100.
Domin aikin OR , idan ɗaya daga cikin waɗannan yanayi gaskiya ne, aikin zai dawo da darajar TRUE a cikin ƙwayar B2.
Don Sakamakon da aikin, duk ka'idoji guda uku dole ne su kasance masu gaskiya don aikin don dawo da darajar TRUE a cell B3.
Haɗa OR da IF, ko ayyukan AND da IF a Excel
Don haka kana da OR da DA ayyuka. Yanzu me?
Ƙara a cikin aikin IF
Lokacin da aka haɗa ɗaya daga cikin wadannan ayyukan biyu tare da aikin IF, maɓallin da aka samo yana da damar da yawa.
Ayyukan nesting a Excel tana nufin sakawa ɗaya aiki a cikin wani. Ayyukan da aka gwada suna aiki a matsayin ɗaya daga cikin muhawarar aiki .
A cikin hoton da ke sama, layukan hudu zuwa bakwai sun ƙunshi siffofi inda aikin KO ko OR yake ƙafa a cikin aikin IF.
A cikin dukan misalai, aikin da aka yi amfani da shi ya zama aiki na farko na IF ko Logical_test .
= IF (OR (A2 <50, A3 <> 75, A4> = 100), "Daidaitan Daidaitawa", "Kuskuren Bayanan")
= IF (AND (A2 <50, A3 <> 75, A4> = 100), YAU (), 1000)
Canza samfurin Formula
A cikin dukkan samfurori a cikin layuka hudu zuwa bakwai, ayyukan AND da OR sune daidai da takwarorinsu a cikin layuka biyu da uku a cikin abin da suke jarraba bayanai a cikin kwayoyin A2 zuwa A4 don ganin idan ya hadu da yanayin da ake bukata.
Ayyukan IF suna amfani da su don sarrafa samfurin da aka samo dangane da abin da aka shigar don aikin na na biyu da na uku.
Wannan fitarwa zai iya zama:
- Rubutu - jere hudu;
- A lamba - jere biyar;
- Da fitarwa daga aiki ko tsari - jere biyar (aiki na yau) da jere shida;
- Kwayar da ba ta sanye ba - jere bakwai (cell B7).
A yanayin saukan IF / AND a cikin cell B5, tun da ba duka ƙwayoyin guda uku a cikin kewayon A2 zuwa A4 ba ne na gaskiya-darajar a cikin cell A4 ba ta fi girma ba ko kuma daidai da 100-DA NA dawo da darajar FALSE.
Ayyukan IF yana amfani da wannan darajar kuma ya dawo da tabbaci na Value_if_false - kwanan wata da aka ba ta aikin yau .
A gefe guda kuma, daftarin IF / OR a jere na hudu ya sake dawo da bayanin Bayanan Daidai saboda:
- Lambar darajar ta AM ya dawo da darajar TRUE - darajar a cikin salula A3 ba daidai ba 75.
- Ayyukan IF din sa'an nan kuma amfani da wannan sakamakon don mayar da martani na Value_if_false : Data Correct .
Rubuta takardar IF / OR ta Excel
Matakan da ke ƙasa suna rufe yadda za a shigar da tsarin IF / OR da ke cikin tantanin halitta B4 a cikin hoton da ke sama. Haka matakan za a iya amfani dashi don shigar da kowane tsari na IF a cikin misali.
Kodayake yana yiwuwa a rubuta irin wannan tsari ta hannun,
= IF (OR (A2 <50, A3 <> 75, A4> = 100), "Daidaitan Daidaitawa", "Kuskuren Bayanan")
mutane da yawa sun fi sauƙi don amfani da maganganun maganganun IF don shigar da tsari da kuma muhawara kamar yadda akwatin maganganu ke kula da haɗin ƙaddamarwa irin su rabuwa tsakanin ƙwararrun tsakanin muhawara da shigar da rubutu a cikin alamomi.
Matakan da ake amfani dashi don shigar da tsarin IF / OR a cikin cell B4 sune:
- Danna kan tantanin halitta B4 don sa shi tantanin halitta mai aiki .
- Danna rubutun Formulas na rubutun .
- Danna maɓallin Magana don buɗe jerin aikin sauke ayyukan.
- Danna IF a cikin jerin don buɗe akwatin maganganu na IF.
- Danna maɓallin Logical_test cikin akwatin maganganu.
- Shigar da cikakken DA aiki: OR (A2 <50, A3 <> 75, A4> = 100) a cikin hanyar Logical_test ta yin amfani da ma'ana don tantance salula idan ana so.
- Danna maɓallin Value_if_true a cikin akwatin maganganu.
- Rubuta a cikin rubutun Data Correct (babu alamomi da ake bukata).
- Danna maɓallin Value_if_false cikin akwatin maganganu.
- Rubuta a cikin rubutu Kuskuren Bayanan.
- Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki.
- Kamar yadda aka riga aka tattauna a sama, wannan tsari ya nuna alamar Value_if_true na Data Correct.
- Lokacin da ka danna kan tantanin B4 , cikakken aikin
= IF (OR (A2 <50, A3 <> 75, A4> = 100), "Data Correct", "Kuskuren Bayanan") ya bayyana a cikin wannan tsari a sama da takardun aiki.