Excel Study · Module 1: First steps
Class 10ROUND, ROUNDUP & ROUNDDOWN
Basics1:40 videoFree
=ROUND(B2,2) rounds a number to 2 decimal places; ROUNDUP rounds away from zero and ROUNDDOWN toward zero (for a positive number: up and down). The second number is how many decimals to keep — 0 means a whole number.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, cell B2 has the number 12.3456. Write a formula that rounds it to 2 decimal places.
The answer that works
✓ checked in Excel=ROUND(B2, 2)
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.