Problem with the "Round" function in Microsoft Excel.?

Question

If I use the round function in Microsoft Excel (eg. =ROUND(A1;2) where A1 was 1.23456) I get the correct feedback of 1.23.

SO FAR SO GOOD

But if I use this value for further math, Excel will always use the original value and not the rounded one...

Why is that?

Answer 1

Use the ROUND formula as part of the entire formula. E.g. in C1, =ROUND(ROUND(A1,2)*ROUND(B1,2),2)



It shouldn't be necessary though. If A1 =5/2, and B1 =ROUND(A1,0) which is 3, C1 =2*B1 shows 6, not 5.

Answer 2

Round Function Excel

Answer 3

Excel Round Function

Answer 4

if your other formulas are referring to the "rounded" answer, it will use the rounded answer. In other words if you put =ROUND(A1, 2) in cell B1, and then reference cell B1 in some other formula (let's say in C1 you enter =B1*2), that formula will use the rounded answer from B1, not the original value from A1.



To check it, enter =B1*2 in cell C1, then press to calculate the answer in toolbar. You will see the answer is 2.46 only and not 2.46912