# 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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…