# Rounding off problem

#### Libra0099

##### Active Member
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?

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Gohar

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

Thank you Peter and Donski,

It works. Great job.

Replies
5
Views
468
Replies
38
Views
2K
Replies
1
Views
428
Replies
18
Views
1K
Replies
7
Views
434

1,221,126
Messages
6,158,086
Members
451,463
Latest member
PowerIon2

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back