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