Home› General Chat
If you need urgent support, call 999 or go to your nearest A&E. To contact our Crisis Messenger (open 24/7) text THEMIX to 85258.
Options

Excel

Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
in General Chat
Got a quick question about a formula question on excel if anyone can help please?

What I need to do is round up a number, but keep the equation intact.

What I have now is

=SUM(cell:cell)/numberofcells

Which always gives me a decimal number... which I need to round up.

So, what I really need is:

=SUM(cell:cell)/numberofcells and then have excel roundup the result from the formula.

Can anyone help me please?

KoG

Comments

  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    Give me half an hour.... I bet I can work it out.... *obviously, someone else might know but ill do it anyway*
  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    use integer function and plus 1?
  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    Oh thank you so much! I wait with baited breath! :thumb:
  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    TheShyBoyInTheCorner wrote:
    use integer function and plus 1?
    I'm not savvy with excel. I just figured out how to add stuff up.... What is this mysterious 'integer' you talk of? :confused:
  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    =INT(SUM(D3 : D16/13)+1) for example.
  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    TheKingOfGlasgow wrote:
    I'm not savvy with excel. I just figured out how to add stuff up.... What is this mysterious 'integer' you talk of? :confused:

    It only take the pre-decimal figure. If you always want to round up, then add 1 and take the pre-decimal figure.

    Only prob is if its an even number it would return something that is 1 higher than it should be. :chin:
  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    Isn't there some sort of option (right click, I think) where you can hoose how many decimal places you want?
  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    =ROUNDUP(SUM(cell1:cellx/x),1)

    That'd work better.

    Where x is the number of cells.
  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    Sofie wrote:
    Isn't there some sort of option (right click, I think) where you can hoose how many decimal places you want?
    You know, sometimes the easiest plans are often the best plans :banghead:

    I tried your forumla ShyBoy, but it's coming up as 'Too few arguments entered'. Thanks for taking the time to do that.

    Sofie's plan works anyway :thumb:
  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    TheKingOfGlasgow wrote:
    You know, sometimes the easiest plans are often the best plans :banghead:

    I tried your forumla ShyBoy, but it's coming up as 'Too few arguments entered'. Thanks for taking the time to do that.

    Sofie's plan works anyway :thumb:

    Good good. :) Took me a few seconds anyway, I did an excel course. :grump:
Sign In or Register to comment.