Jifunze Excel: AND(), OR() na IF() Functions kwa Urahisi

Gundua formulas muhimu za Excel: AND(), OR(), na IF(). Angalia masharti kadhaa kwa wakati mmoja, tengeneza ripoti, na jifunze mifumo ya Excel bure. Pata msaada wa WhatsApp pia.”

1. AND() Function

AND() inarudisha TRUE ikiwa conditions zote ni kweli, na FALSE ikiwa angalau moja ni false.

Syntax:

AND(logical1, [logical2], …)

Mfano wa Kutumia AND():

Score (A2) Attendance % (B2) Formula Matokeo (Simulated Screenshot)
60 80% =AND(A2>50,B2>=75%) ✅ TRUE
45 80% =AND(A2>50,B2>=75%) ❌ FALSE
60 70% =AND(A2>50,B2>=75%) ❌ FALSE

Kutumia IF() na AND():

=IF(AND(A2>=50, B2>=75%), "Pass", "Fail")

“Pass” itatolewa tu ikiwa score ≥ 50 na attendance ≥ 75%.

2. OR() Function

OR() inarudisha TRUE ikiwa condition moja tu ni kweli, na FALSE ikiwa zote ni false.

Syntax:

OR(logical1, [logical2], …)

Mfano wa Kutumia OR():

Score (A2) Attendance % (B2) Formula Matokeo (Simulated Screenshot)
85 80% =OR(A2>80,B2<60%) ✅ TRUE
45 70% =OR(A2>80,B2<60%) ✅ TRUE
60 65% =OR(A2>80,B2<60%) ❌ FALSE

Kutumia IF() na OR():

=IF(OR(A2<50, B2<60%), "Attention", "OK")

“Attention” itatolewa ikiwa score au attendance iko chini ya kiwango cha chini.

3. Kutumia AND() na OR() Pamoja

Unaweza kuunganisha AND() na OR() kwa masharti changamano.

Mfano: Kuangalia Bidhaa kwa Stock na Status

Quantity (C2) Status (D2) Formula Matokeo (Simulated Screenshot)
10 Available =IF(AND(C2>0,D2="Available"),"Ready","Not Ready") ✅ Ready
0 Available =IF(AND(C2>0,D2="Available"),"Ready","Not Ready") ❌ Not Ready
5 Out of Stock =IF(OR(C2=0,D2="Out of Stock"),"Not Ready","Ready") ❌ Not Ready

AND() inahakikisha masharti yote yametimizwa, OR() inatoa TRUE ikiwa angalau moja ya masharti yametimizwa.

4. Tips Muhimu

AND() na OR() mara nyingi hutumika ndani ya IF() kufanya uamuzi wa data.

OR() inaweza kuchanganywa na AND() kwa masharti changamano zaidi.

Zinaweza kuangalia namba, maandiko, au tarehe.

Formulas hizi zinaweza kusaidia sana kwa ripoti, dashboard, na usimamizi wa data.

Links Muhimu

Tazama tutorials zaidi za Excel: https://www.faulink.com

Download mifumo ya Excel bure: https://www.faulink.com/excel_mifumo.php

Msaada wa WhatsApp: https://wa.me/255693118509