how to get a range of cells rounded off to the nearest value?

S

sumesh56

i have the following data in cells A2:E2. (14.1,25,26.8,17.9,,48.6)
want to get the figures without the decimals. i tried the following wit
negative result.
=Round(A2:E2,0)
i can get the required result in three steps
1.=Sum(A2:E2,0) gives me the result with one decimal
2.select cell at the top and click on the ribbon to reduce the decima
to nil.
3. use the fill handle
is it possible to accomplish the task with one formula? thank
 
S

Spencer101

sumesh56;1610768 said:
i have the following data in cells A2:E2. (14.1,25,26.8,17.9,,48.6)
want to get the figures without the decimals. i tried the following wit
negative result.
=Round(A2:E2,0)
i can get the required result in three steps
1.=Sum(A2:E2,0) gives me the result with one decimal
2.select cell at the top and click on the ribbon to reduce the decima
to nil.
3. use the fill handle
is it possible to accomplish the task with one formula? thanks

Use round on single cells rather that the range.
So, =ROUND(A2,0) and drag/copy across.

If these cells show as having a decimal place but all of those are zero
then it's formatting rather than the formula not working.

Also worth considering ROUNDDOWN / ROUNDUP depending on how ou need th
results. 17.9 for example wold become 18 with ROUND or ROUNDUP, but 1
with ROUNDDOWN
 
K

Kevin@Radstock

Hi sumesh56

Or summing the interger (Without rounding)
=SUMPRODUCT(INT(A2:E2))
 
S

sumesh56

Spencer101;1610772 said:
You don't have to mark them as solved on this forum.

The icon you see is when characters in a formula make those littl
emoticons.
So when you have a formula that concerns column D for example D:
(without a space) becomes D:D.

thanks for the guidance. have a nice day
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top