Question

Explain ‘ROUND’ function of Excel.

Hint:

Use ROUND to avoid calculation errors due to long decimals, especially in financial and tax computations.

Answer 1

The ROUND function in Excel helps eliminate unwanted decimal places. The syntax is: \[ \texttt{=ROUND(number, num\_digits)} \] Explanation:

• If num\_digits = 0, it rounds to the nearest integer.
• If positive, rounds to that number of decimal places.
• If negative, rounds to left of the decimal (e.g., nearest 10, 100).

Example: \[ =ROUND(12.345, 2) \Rightarrow 12.35 ; =ROUND(248, -1) \Rightarrow 250 \]