Wakati unafanya hesabu za Excel, mara nyingi unataka kupata average ya range ya cells na kuipanga hadi decimal chache ili iwe rahisi kusoma. Formula hii inakusaidia kufanya hivyo:

=ROUND(AVERAGE(G2:O2),2)

📘 Maana ya Formula Hii

AVERAGE(G2:O2)

Hii inachukua cells kutoka G2 hadi O2 na inarudisha average yao.

Hasa, Excel inahesabu jumla ya namba zote na kugawanya kwa idadi ya namba zilizo na thamani.

ROUND(...,2)

ROUND inazungusha (round) namba hadi decimal unayochagua.

Hapa 2 inamaanisha decimal 2, kwa mfano:

7.236 → 7.24

5.123 → 5.12

🎯 Mfano Rahisi
G2 H2 I2 J2 K2 L2 M2 N2 O2 Average Result (Rounded)
5 6 7 8 9 5 6 7 8 6.78 6.78
10 12 15 14 13 11 10 12 14 12.33 12.33

Kwa kutumia ROUND, unapata average safi bila kuonyesha decimal nyingi zisizo za lazima.

🔗 Links Muhimu Za Kujifunza Zaidi

🌐 Faulink Official Website:
https://www.faulink.com/

📘 Excel Mifumo – Ready to Use:
https://www.faulink.com/excel_mifumo.php

📲 Piga / WhatsApp kwa msaada wa haraka:
https://wa.me/255693118509

🧩 Hitimisho

Kutumia ROUND pamoja na AVERAGE ni njia rahisi na sahihi ya kuonyesha average safi na readable kwenye Excel.
Hii ni formula muhimu hasa kwa reports, scoring systems, na analytics.