Gundua jinsi ya kutumia OR() kwenye Excel kuangalia masharti kadhaa kwa wakati mmoja. Tazama tutorials zaidi, pakua mifumo ya Excel bure, na pata msaada wa WhatsApp.”
OR() Function katika Excel
OR() ni logical function inayorudisha TRUE ikiwa angalau condition moja ni true, na FALSE ikiwa zote ni false.
Syntax:
OR(logical1, [logical2], …)
logical1, logical2, … = masharti unayotaka kuangalia.
Mfano Rahisi wa OR()
Angalia score kubwa kuliko 80 au ndogo kuliko 50
=OR(A2>80, A2<50)
A2 = 85 → TRUE (kwa sababu > 80)
A2 = 45 → TRUE (kwa sababu < 50)
A2 = 60 → FALSE
Kutumia OR() na IF()
Mfano: Tuma “Attention” ikiwa score < 50 au attendance < 60%
=IF(OR(A2<50, B2<60%), "Attention", "OK")
A2 = score
B2 = attendance percentage
Hii inamaanisha: "Attention" itatolewa ikiwa score au attendance iko chini ya kiwango cha chini.
Mfano 2: Kuangalia Bidhaa
=IF(OR(C2=0, D2="Out of Stock"), "Not Ready", "Ready for Sale")
C2 = quantity
D2 = status
Bidhaa haiko tayari ikiwa quantity = 0 au status = Out of Stock.
Tips za Kutumia OR()
OR() inaweza kuunganishwa na AND() kwa masharti changamano.
Inarudisha TRUE/FALSE, hivyo mara nyingi inatumika ndani ya IF().
Inaweza kuangalia masharti ya namba, maandiko, au tarehe.
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