Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default How do I calculate an average by a certain percentage?

My husband is a junior college teacher and needed to know how to calculate an
average by a certain percent. Say if homework was 20% of their total grade,
how would he write the formula for that?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default How do I calculate an average by a certain percentage?

Is it not just a simple

=AVERAGE(A1:A20)*20%

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"cwilson" wrote in message
...
My husband is a junior college teacher and needed to know how to calculate

an
average by a certain percent. Say if homework was 20% of their total

grade,
how would he write the formula for that?



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
Calculate average based on date and other criteria Kycajun Excel Discussion (Misc queries) 3 July 14th 06 10:08 PM
Looking-up Columns w/calc'd Values ONLY to Calculate Average sony654 Excel Worksheet Functions 5 April 21st 06 06:21 AM
formula to calculate the average of a range basing on condition Krishna Mohan Excel Worksheet Functions 4 June 21st 05 11:26 AM
calculate average hours and minutes llstephens Excel Worksheet Functions 4 November 30th 04 03:47 PM
calculate average hours worked llstephens Excel Worksheet Functions 1 November 24th 04 02:37 PM


All times are GMT +1. The time now is 12:32 AM.

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

About Us

"It's about Microsoft Excel"