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

Gundua formulas muhimu za Excel: IF(), AND(), OR(), na IFERROR(). Angalia masharti kadhaa, 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. Kutumia AND(), OR() na IFERROR() Pamoja

Mfano: Kuangalia Bidhaa kwa Stock na Status

=IF(AND(C2>0,D2="Available"),"Ready","Not Ready")


AND() inahakikisha masharti yote yametimizwa

OR() inaweza kuunganishwa kwa masharti changamano

IFERROR() inaweza kuweka default value ikiwa kuna error

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
6. Tips Muhimu

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

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