“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
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
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
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