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

Gundua formulas muhimu za Excel: IF(), AND(), OR(), IFERROR(), na SWITCH(). Angalia masharti, kuepuka errors, na tengeneza ripoti safi. Tazama tutorials zaidi na pakua mifumo ya Excel bure.”

1. IF() Function

IF() ni formula ya conditional inayorudisha matokeo tofauti kulingana na condition.

Syntax:

IF(logical_test, value_if_true, value_if_false)


Mfano wa IF():

Score (A2) Formula Matokeo
75 =IF(A2>=50,"Pass","Fail") Pass
45 =IF(A2>=50,"Pass","Fail") Fail
2. AND() Function

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

Kutumia IF() na AND():

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

Score (A2) Attendance % (B2) Matokeo
60 80% Pass
45 80% Fail
60 70% Fail
3. OR() Function

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

Kutumia IF() na OR():

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

Score (A2) Attendance % (B2) Matokeo
85 80% OK
45 70% Attention
60 55% Attention
4. IFERROR() Function

IFERROR() inatumiwa kubadilisha errors kuwa matokeo unayotaka badala ya #DIV/0!, #N/A, #VALUE!, nk.

Mfano wa IFERROR():

=IFERROR(A2/B2, "Error: Division by zero")

A2 B2 Formula Matokeo
50 0 =IFERROR(A2/B2,"Error") Error: Division by zero
50 10 =IFERROR(A2/B2,"Error") 5

Mfano wa IFERROR() na VLOOKUP:

=IFERROR(VLOOKUP(B2,Sheet2!A:B,2,FALSE),"Not Found")

5. SWITCH() Function

SWITCH() ni rahisi kuliko IF() nyingi na inachagua matokeo kulingana na thamani fulani.

Syntax:

SWITCH(expression, value1, result1, [value2, result2], ..., [default])


Mfano: Badilisha grade kuwa comment

=SWITCH(B2, "A","Excellent", "B","Good", "C","Average", "D","Poor", "F","Fail", "Invalid")

Grade (B2) Matokeo
A Excellent
B Good
F Fail
E Invalid
6. Kutumia AND(), OR(), IFERROR() na SWITCH() Pamoja

Mfano: Kuangalia Bidhaa kwa Stock na Status

=IFERROR(SWITCH(C2, 0,"Not Ready", D2="Out of Stock","Not Ready", "Ready"),"Check Data")

Quantity (C2) Status (D2) Matokeo
10 Available Ready
0 Available Not Ready
5 Out of Stock Not Ready
7. Tips Muhimu

AND(), OR() na IF() hutumika pamoja kufanya uamuzi changamano.

SWITCH() inafanya formulas kuwa concise kuliko IF() nyingi.

IFERROR() inahakikisha worksheets zinabaki safi na zenye professional look.

Formulas hizi zinaweza kuangalia namba, maandiko, au tarehe, na zinasaidia sana kwa ripoti na dashboards.

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