Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Grd Grd is offline
external usenet poster
 
Posts: 118
Default Average and Round together

Hi there,

I want to use both Average and Round functions at the same time.

Can they be used together if so in what order?. My range of figures is A2:a22.

Any help greatly appreciated

Thanks

Suzanne
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Average and Round together

Hi Suzanne,

Yes, you can definitely use the
Code:
Average
and
Code:
Round
functions together in Excel. Here's how you can do it:

  1. First, select a cell where you want to display the rounded average value.
  2. Then, type the following formula into the formula bar:
    Code:
    =ROUND(AVERAGE(A2:A22),2)
  3. In this formula, the
    Code:
    AVERAGE
    function calculates the average of the range A2:A22, and the
    Code:
    ROUND
    function rounds the result to two decimal places.
  4. Once you've typed the formula, press Enter to calculate the result.
  5. The cell will now display the rounded average value of the range A2:A22.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,081
Default Average and Round together

1) You can use them together
2) the order depends on what you want to accompliss: do you want the
average of rounded values, or do you want to round the calculated average

In the first case you need an array formula, i.e., one you enter by pressing
Ctrl-Shift-Enter

=average(round(a1:a10,N)) replace the N with the number of digits

The second one is simply

=round(average(A1:A10),N)




"Grd" wrote:

Hi there,

I want to use both Average and Round functions at the same time.

Can they be used together if so in what order?. My range of figures is A2:a22.

Any help greatly appreciated

Thanks

Suzanne

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Grd Grd is offline
external usenet poster
 
Posts: 118
Default Average and Round together

Excellent

Tx

S

"Duke Carey" wrote:

1) You can use them together
2) the order depends on what you want to accompliss: do you want the
average of rounded values, or do you want to round the calculated average

In the first case you need an array formula, i.e., one you enter by pressing
Ctrl-Shift-Enter

=average(round(a1:a10,N)) replace the N with the number of digits

The second one is simply

=round(average(A1:A10),N)




"Grd" wrote:

Hi there,

I want to use both Average and Round functions at the same time.

Can they be used together if so in what order?. My range of figures is A2:a22.

Any help greatly appreciated

Thanks

Suzanne

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
average cells, show 0 if nothing to average Kycajun Excel Discussion (Misc queries) 8 June 21st 06 07:36 PM
Error Handling #N/A with AVERAGE Function - Average of values in Row Sam via OfficeKB.com Excel Worksheet Functions 13 July 31st 05 03:59 PM
Weighed Average of a weiged average when there are blanks krl - ExcelForums.com Excel Discussion (Misc queries) 1 July 6th 05 07:37 PM
how does one convert text to a formula "average(A:A)" to =average( phshirk Excel Worksheet Functions 4 April 14th 05 01:20 AM
How do I ROUND() round off decimals of a column dataset? Højrup Excel Worksheet Functions 2 January 12th 05 11:50 AM


All times are GMT +1. The time now is 01:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"