Jifunze Excel AND() Function: Jinsi ya Kuangalia Masharti Kadhaa kwa Wakati Mmoja

“Gundua jinsi ya kutumia AND() kwenye Excel kuangalia masharti kadhaa kwa wakati mmoja. Tazama tutorials zaidi, pakua mifumo ya Excel bure, na pata msaada wa WhatsApp.”

And() Function katika Excel

AND() ni logical function inayorudisha TRUE ikiwa masharti yote yaliyowekwa ni kweli, na FALSE ikiwa angalau moja ni si kweli.

Syntax:

AND(logical1, [logical2], …)

logical1, logical2, … = masharti unayotaka kuangalia.

Mfano wa Kutumia AND()

Mfano 1: Angalia ikiwa score ni kubwa kuliko 50 na ndogo kuliko 80

=AND(A2>50, A2<80)

A2 = 60 → TRUE

A2 = 45 → FALSE

A2 = 85 → FALSE

Kutumia AND() na IF()

Kutumia AND() ndani ya IF() ni njia ya kawaida sana:
Mfano: Tuma “Pass” au “Fail” kulingana na score na attendance

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

A2 = score

B2 = attendance percentage

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

Mfano 2: Kuangalia Upatikanaji wa Bidhaa
=IF(AND(C2>0, D2="Available"), "Ready for Sale", "Not Ready")

C2 = quantity

D2 = status

Tips za Kutumia AND()

AND() inaweza kuunganishwa na OR() 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