Rounding off problem

[Libra0099]

Good day,

I am working on a large excel sheet. I have a problem regarding casting (summation) of this sheet.

All figures are rounding to 2 decimal places which effects on grand totals. I want to remove these decimal places. For example


2.4
2.3
Grand total of above figures is 4.7

But when I round these figures to Zero decimal place it show like this way

2
2
Grand total after rounding is 5

I want to remove decimal places in whole sheet. I know round formula i.e. =round(number, num_digits)

But for this I have to insert columns. This is very time consuming method. Can anyone advice me for simple way.

One thing more, Is this possible to apply round formula on the same cell?


I hope I better defined my problem. Please advice.

Thanks in advance.

 

[Peter_SSs]

Gohar

Have a look at Tools|Options|Calculation|Precision as displayed. You should read up about this in the Help file before applying it on your sheet as it permanently alters your original data.

 

[Domski]

Hi,

You can use a formula like this:

=SUM(ROUND(A1:A10,0))

Where A1:A10 holds the figures to round and sum.

Confirmed with Ctrl+Shift+Enter as it's an array formula.

Hope it helps,

Dom

 

[Libra0099]

Thank you Peter and Donski,

It works. Great job.