Skip to content

AJ's Techie & Wacky World

  • ✨ AI Helper
  • 🎓 Courses
  • Excel & Office
    • Charts & Dashboards
    • Excel 365 & Dynamic Arrays
    • Excel for Finance
    • Excel for India
    • Excel Formulas
    • Excel Functions A–Z
    • Excel VBA
    • Formula Combos
    • Power BI & DAX
    • Power Query & Pivots
    • Python in Excel
    • Google Workspace
    • Outlook
    • PowerPoint
    • Word
  • Coding
    • Cloud & Servers
    • Dev Tools
    • Java
    • JavaScript
    • PowerShell
    • Python
    • R
    • Rust
    • SQL
    • VBA to Python Migration
  • Automation
    • AutoHotkey
    • Automation Basics
    • Office Scripts
    • Power Automate
    • Python Automation
    • SAP GUI Scripting
  • AI & ML
    • AI Agents & RAG
    • AI Agents & Workflows
    • AI Tools
    • Build Your Own LLM
    • Deep Learning
    • LLMs
    • Machine Learning
    • Prompt Engineering
    • Vibe Coding
  • ERP
    • Essbase
    • Oracle EPM Cloud
    • Oracle Smart View
    • SAP
    • Tally & Busy
    • Tax & Compliance
  • Tech Tips
    • Internet & Browser
    • Phone
    • Security & Privacy
    • Windows
    • Work Smarter
  • Wacky World
    • Fun Facts
    • History
    • Science
    • All Wacky Facts
  • Tools
    • Formula Lab
    • VBA Playground
    • Macro Recorder
    • VBA Challenges
    • SQL Playground
    • Shortcut Trainer
    • Date & Workday Calculator
    • EMI & SIP Calculator
    • Income Tax: Old vs New
    • GST Calculator
    • Regex Tester
  • About
    • Projects
    • Contact

ROUND Function in Excel: Round to Any Number of Digits

28 September 20261 March 2016 by Atul Vij
ROUND Function in Excel: Round to Any Number of Digits featured illustration

ROUND rounds a number to a given number of digits. Unlike cell formatting, it changes the actual value — important for invoices and totals that must match.

Categories Excel Functions A–Z, Math & Trig

MAX Function in Excel: Largest Value in a Range

28 September 20269 February 2016 by Atul Vij
MAX Function in Excel: Largest Value in a Range featured illustration

StatisticalLevel: BeginnerAvailable in: Excel 2007+MAX returns the largest number. MIN is its mirror. Both ignore text and blanks.Syntax=MAX(number1.

Categories Excel Functions A–Z, Statistical

COUNTA Function in Excel: Count Non-Empty Cells

3 November 20262 February 2016 by Atul Vij
COUNTA Function in Excel: Count Non-Empty Cells featured illustration

Count the number of non-empty cells in a range, tallying numbers, text strings, dates, boolean values, and error codes.

Categories Excel Functions A–Z, Statistical

COUNT Function in Excel: Count Cells That Contain Numbers

3 November 202626 January 2016 by Atul Vij
COUNT Function in Excel: Count Cells That Contain Numbers featured illustration

Count the number of cells in a range or argument list that contain numbers, including positive/negative values, decimals, and dates.

Categories Excel Functions A–Z, Statistical

AVERAGE Function in Excel: Arithmetic Mean of Numbers

28 September 202619 January 2016 by Atul Vij
AVERAGE Function in Excel: Arithmetic Mean of Numbers featured illustration

AVERAGE returns the arithmetic mean: the sum divided by the count of numbers. Empty cells and text are ignored, but zeros are counted.

Categories Excel Functions A–Z, Statistical

SUM Function in Excel: Add Numbers, Ranges and Whole Columns

28 September 202612 January 2016 by Atul Vij
SUM Function in Excel: Add Numbers, Ranges and Whole Columns featured illustration

SUM adds numbers, cell references and ranges. It ignores text and empty cells, which makes it the safest way to total a column.

Categories Excel Functions A–Z, Math & Trig
Advertisement
Newer posts
← Previous Page1 … Page101 Page102

Popular topics

ExcelExcel VBAPower Query & PivotsExcel for FinanceAutomationSAP & OracleCodingAI & MLTech tipsWacky World

Recent posts

  • Basics of VBA / Macros Chapter – 82 (Userform Part-3)
  • Basics of VBA / Macros Chapter – 81 (Userform Part-2)
  • Basics of VBA / Macros Chapter – 80 (Userform Part-1)
  • Basics of VBA / Macros Chapter – 79 (ActiveX Controls Part-8)
  • Basics of VBA / Macros Chapter – 68 (Application Object Part-1)
  • Basics of VBA / Macros Chapter – 51 (Time and Date Part-8)

🤯 Wacky fact of the day · Human Body

Fingerprints form in the womb and never change.

Fingerprint ridges form by around the 17th week of pregnancy. Even identical twins have different fingerprints.

Why? How? →Source ↗

© 2026 AJ's Techie & Wacky World • Built with GeneratePress
© 2026 Atul Vij · AJ’s Techie & Wacky World
AboutProjectsFree ToolsContactPrivacyDisclaimerGitHub
Did you know?

Why? →