Re: Round up an average

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Perfect. Thank you :-)

"T. Valko" wrote:

=roundup(AVERAGE(A1:A5))

You have to tell it how many digits to round to For example, to roundup to
the nearest whole number:

=ROUNDUP(AVERAGE(A1:A5),0)

--
Biff
Microsoft Excel MVP


"Kirstin" <Kirstin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F3B5178C-8EF2-4501-BF95-759CA3F5DA58@xxxxxxxxxxxxxxxx
I'm trying to do something pretty simple (I thought). I would like to
average a column and then round up the results. I'm doing the formula:

=roundup(AVERAGE(A1:A5))

And receiving an error message that it has too few arguments. How do I
round up an average?



.

Relevant Pages

  • Re: XQ and ->Qpi bug on large X
    ... you shouldn't be rounding to only two digits ... I am trying to make a similar point here about rounding; ... and round it, ... prior to using the input values in calculations. ...
    (comp.sys.hp48)
  • Re: How do I round up to the nearest Dollar in Excel??
    ... Wouldn't that round to the nearest, and give 6806 not 6807, Bob? ... Doesn't it need ROUNDUP or CEILING? ... you) is been a beast for me and will be used in numerous cells and ...
    (microsoft.public.excel.misc)
  • Re: Decimall Float Question
    ... the number other than to round the decimal part. ... 'bankers rounding' to the nearest even number is not required). ... the FAQ code includes having a variable number of digits after ... // Convert number to string and split ... ...
    (comp.lang.javascript)
  • Re: check decimal and if numeric
    ... so effectively truncates an subsequent digits for positive numbers. ... It's different when you round negative numbers down, ... decimals, who's to say the third or fourth digit was the one that was in error? ...
    (microsoft.public.access.formscoding)
  • Re: Rounding to Hundredths
    ... I could type in "RoundUP" to write ... the calculated expression, but when I clicked F1 on the ... only listed "round". ... >> sum to the nearest 100th. ...
    (microsoft.public.access.reports)