Excel Formulas Table 1 - 50

Objectives: Excel Formulas Table

Excel Formulas Table (Jedwali la Formulas za Excel 100)

Excel Formulas Table / Jedwali la Formulas za Excel (100)

This table contains 100 essential Excel formulas, explained in English and Swahili with simple examples.
Jedwali hili lina formulas 100 muhimu za Excel zikiwa na maelezo ya Kiingereza na Kiswahili na mifano rahisi kuelewa.

No. Formula Name / Jina la Formula Description / Maelezo Example / Mfano
1=SUM()Adds numbers together / Kujumlisha namba=SUM(A1:A5)
2=AVERAGE()Finds the average / Kupata wastani wa namba=AVERAGE(B1:B10)
3=COUNT()Counts numeric cells / Kuhesabu seli zenye namba=COUNT(A1:A10)
4=COUNTA()Counts non-empty cells / Kuhesabu seli zisizo tupu=COUNTA(A1:A10)
5=COUNTBLANK()Counts empty cells / Kuhesabu seli tupu=COUNTBLANK(A1:A10)
6=MAX()Finds largest value / Kupata namba kubwa zaidi=MAX(C1:C20)
7=MIN()Finds smallest value / Kupata namba ndogo zaidi=MIN(C1:C20)
8=IF()Conditional check / Sharti la IF=IF(A1>50,"Pass","Fail")
9=AND()All TRUE / Masharti yote lazima yawe sahihi=AND(A1>10,B1<20)
10=OR()Any TRUE / Angalau sharti moja sahihi=OR(A1>10,B1<20)
11=NOT()Reverses TRUE/FALSE / Kugeuza mantiki=NOT(A1>10)
12=LEN()Counts characters / Kuhesabu herufi=LEN(A1)
13=LEFT()Extract from left / Kuchukua herufi za mwanzo=LEFT(A1,3)
14=RIGHT()Extract from right / Kuchukua herufi za mwisho=RIGHT(A1,4)
15=MID()Extract from middle / Kuchukua katikati=MID(A1,2,5)
16=TRIM()Removes extra spaces / Kuondoa nafasi zisizo lazima=TRIM(A1)
17=CONCAT()Joins text / Kuunganisha maandishi=CONCAT(A1," ",B1)
18=TEXTJOIN()Joins with separator / Kuunganisha na separator=TEXTJOIN("-",TRUE,A1:A3)
19=UPPER()Uppercase / Herufi kubwa=UPPER(A1)
20=LOWER()Lowercase / Herufi ndogo=LOWER(A1)
21=PROPER()Capitalize first / Kuweka herufi ya kwanza kubwa=PROPER(A1)
22=NOW()Current date & time / Tarehe na muda wa sasa=NOW()
23=TODAY()Current date / Tarehe ya leo=TODAY()
24=DATE()Create date / Kuunda tarehe=DATE(2025,10,15)
25=DAY()Extract day / Kuchukua siku=DAY(A1)
26=MONTH()Extract month / Kuchukua mwezi=MONTH(A1)
27=YEAR()Extract year / Kuchukua mwaka=YEAR(A1)
28=HOUR()Extract hour / Kuchukua saa=HOUR(A1)
29=MINUTE()Extract minute / Kuchukua dakika=MINUTE(A1)
30=SECOND()Extract second / Kuchukua sekunde=SECOND(A1)
31=WEEKDAY()Day of week / Siku ya wiki=WEEKDAY(A1)
32=WEEKNUM()Week number / Namba ya wiki=WEEKNUM(A1)
33=VLOOKUP()Vertical lookup / Kutafuta wima=VLOOKUP(A1,B2:D10,3,FALSE)
34=HLOOKUP()Horizontal lookup / Kutafuta mlalo=HLOOKUP(A1,B1:H5,3,FALSE)
35=XLOOKUP()Modern lookup / Kutafuta kwa urahisi zaidi=XLOOKUP(A1,B1:B10,C1:C10,"Not Found")
36=INDEX()Value by position / Thamani kwa nafasi=INDEX(A1:C10,2,3)
37=MATCH()Finds position / Nafasi ya kitu=MATCH("John",A1:A10,0)
38=OFFSET()Returns offset range / Range kwa nafasi=OFFSET(A1,2,1)
39=CHOOSE()Pick by index / Kuchagua kwa namba=CHOOSE(2,"Red","Blue","Green")
40=ROUND()Round number / Kurekebisha namba=ROUND(A1,2)
41=ROUNDUP()Round up / Kuweka juu=ROUNDUP(A1,0)
42=ROUNDDOWN()Round down / Kuweka chini=ROUNDDOWN(A1,0)
43=INT()Integer part / Sehemu ya namba kamili=INT(A1)
44=MOD()Remainder / Baki=MOD(A1,2)
45=POWER()Exponent / Kuinua nguvu=POWER(A1,2)
46=SQRT()Square root / Mizizi ya mraba=SQRT(A1)
47=ABS()Absolute value / Thamani halisi=ABS(A1)
48=RAND()Random number 0–1 / Namba ya kubahatisha=RAND()
49=RANDBETWEEN()Random within range / Namba ya bahati kati ya mipaka=RANDBETWEEN(1,100)
50=SUBTOTAL()Subtotal calculation / Hesabu ndogo=SUBTOTAL(9,A1:A10)

Reference Book: N/A

Author name: SIR H.A.Mwala Work email: biasharaboraofficials@gmail.com
#MWALA_LEARN Powered by MwalaJS #https://mwalajs.biasharabora.com
#https://educenter.biasharabora.com

:: 1::

⬅ ➡