18/08/2026
📗 Microsoft Excel ROUND Function Explained | ROUND Formula with GST Bill Example | Excel Formula
Learn the ROUND Function in Microsoft Excel with a practical GST Bill Calculation example. ROUND helps you reduce unnecessary decimal places and present calculated values in a clean and accurate format.
🧾 Real Excel Example
If GST calculation gives:
₹152.9235
Using:
=ROUND(D3,2)
Excel returns:
✅ ₹152.92
Here, 2 means Excel will keep 2 decimal places.
Another example:
849.576 → 849.58
📚 In This Lesson
✅ What is the ROUND Function?
✅ ROUND Formula Syntax
✅ How to round decimal numbers
✅ Meaning of num_digits
✅ GST & Invoice Example
✅ Financial Calculations
✅ ROUND with Excel Reports
✅ Practical use of ROUND Function
🎯 ROUND is useful for GST Calculations, Invoices, Financial Reports, Price Calculations, Marks, Percentages, Sales Reports, and everyday Excel work.
📌 This Excel tutorial is useful for Computer Awareness, Microsoft Excel, Office Automation and students preparing for SSC, Railway, BELTRON, BPSC, Banking, Bihar Police, CHSL, CGL and other Competitive Exams.
👉 Follow Modern Computer Institute Pvt. Ltd. for daily Excel formulas, practical Excel examples, Computer Awareness and Microsoft Office tutorials.
