Rounding off problem

Libra0099

Active Member
Joined
Apr 28, 2007
Messages
273
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.
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
57,262
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
Jan 18, 2005
Messages
7,292
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
 

Forum statistics

Threads
1,181,103
Messages
5,928,077
Members
436,587
Latest member
Slicesofquince

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top