Jifunze Excel OR() Function: Angalia Masharti Kadhaa kwa Urahisi

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