Excel roundup formula

  recap 17:47 11 Feb 2006
Locked

I have been trying to solve a little Roundup problem.

Say for instance Row 1 from A1:G1 has numeric values with 3 decimal places. I am trying to get the total to round these up, I have tried a number of ways to do this with out any luck. there must be a simple answer of which I am not seeing?

Any help would be gratefully appreciated.

  csqwared 18:03 11 Feb 2006

Not quite sure what you mean by "round up". Do you just want a single figure in the total or will you still want decimals, and if so how many decimal places?

  Eric10 18:07 11 Feb 2006

Do you mean that you want a total that reflects the rounded up value of each of the cells A1 to G1 rather than just a total which is itself rounded up as in =ROUNDUP(SUM(A1:G1),0)?

  VoG II 18:11 11 Feb 2006

I'm not sure either. Can you expand a bit, recap.

  recap 18:59 11 Feb 2006

Yes, sorry folks. Each cell has a number like 234.567 and I want to round that number up to a whole number 234 in the total.

  recap 19:01 11 Feb 2006

I have just tried Eric10 formula and it works. I was not including the ,0) part of the forumla.

Thanks for all your time folks.
recap

  VoG II 19:01 11 Feb 2006

Eric10's formula should do what you want.

Also Format|Cells and change the number formatting to 0 decimal places.

  recap 19:04 11 Feb 2006

Thanks VoG™, but it's a little complicated, I have all other formulae done but the roundup one.

Thanks again.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment regarder des séries et talk-shows américains en France ?