Excel roundup formula

  recap 17:47 11 Feb 06
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 06

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 06

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 06

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

  recap 18:59 11 Feb 06

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 06

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 06

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 06

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.

Surface Pro 5 News - release date, UK price, features, specs

Animator Emanuele Kabu’s psychedelic video is a stunning tribute to Lisbon city

Best Mac antivirus 2017