Jifunze Excel SWITCH() Function: Mbinu Rahisi ya Kuchagua Matokeo

Gundua jinsi ya kutumia SWITCH() kwenye Excel kuchagua matokeo tofauti kulingana na thamani fulani. Tazama tutorials zaidi, pakua mifumo ya Excel bure, na pata msaada wa WhatsApp.”

1. SWITCH() Function

SWITCH() ni logical function inayotumiwa kuchagua kati ya thamani nyingi na kurudisha matokeo kulingana na value. Ni rahisi kuliko IF() nyingi zinazojirudia.

Syntax:

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

expression = thamani unayotaka kuangalia

value1, value2… = thamani zinazoweza kutokea

result1, result2… = matokeo yanayotolewa ikiwa expression inalingana na value

default = matokeo ikiwa hakuna match

2. Mfano Rahisi

Mfano 1: Badilisha namba kuwa jina la siku

=SWITCH(A2, 1,"Monday", 2,"Tuesday", 3,"Wednesday", 4,"Thursday", 5,"Friday", 6,"Saturday", 7,"Sunday", "Invalid")

A2 = 3 → Wednesday

A2 = 8 → Invalid

3. SWITCH() vs IF()

SWITCH() inafaa zaidi kwa masharti mengi ya kulinganisha thamani moja.

IF() zinakuwa ngumu kusoma na kusimamia wakati masharti ni mengi.

Mfano:

=IF(A2=1,"Monday",IF(A2=2,"Tuesday",IF(A2=3,"Wednesday","Invalid")))

SWITCH() ni concise kuliko hii formula ya IF() nyingi.

4. Kutumia SWITCH() na Formulas Zingine

Mfano: Badilisha grade kuwa comment

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

B2 = “B” → Good

B2 = “F” → Fail

B2 = “E” → Invalid

5. Tips Muhimu

SWITCH() ni rahisi kusoma kuliko IF() nyingi.

Inaweza kurudisha namba, maandiko, au hata formulas kama result.

Default value inasaidia kushughulikia thamani ambazo hazipo kwenye list.

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