Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Senior Member
 
Posts: 118
Arrow percentage calculation

hai everybody,
i have a column containing marks of students. say E4:E35.
the marks of individual students is in out of 90.
i need to calculate the class average of the marks in 100.
i used the following formula but excel gives me error.

=SUM(((E4:E35)/32))/90*100

help me plz. thanks. have a nice day.
Attached Files
File Type: zip MKLIST FOR EBR.zip (6.9 KB, 89 views)
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 587
Default percentage calculation

hi sumesh56,

=SUM(E4:E35)/32/90*100

--
isabelle


Le 2012-10-12 21:20, sumesh56 a écrit :
hai everybody,
i have a column containing marks of students. say E4:E35.
the marks of individual students is in out of 90.
i need to calculate the class average of the marks in 100.
i used the following formula but excel gives me error.

=SUM(((E4:E35)/32))/90*100

help me plz. thanks. have a nice day.


+-------------------------------------------------------------------+
|Filename: MKLIST FOR EBR.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=620|
+-------------------------------------------------------------------+



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 51
Default percentage calculation

Il 13/10/2012 03:20, sumesh56 ha scritto:
hai everybody,
i have a column containing marks of students. say E4:E35.
the marks of individual students is in out of 90.
i need to calculate the class average of the marks in 100.
i used the following formula but excel gives me error.

=SUM(((E4:E35)/32))/90*100

help me plz. thanks. have a nice day.


+-------------------------------------------------------------------+
|Filename: MKLIST FOR EBR.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=620|
+-------------------------------------------------------------------+





=AVERAGE(E4:E35)/90*100

E.
  #4   Report Post  
Senior Member
 
Posts: 118
Default

Quote:
Originally Posted by plinius View Post
Il 13/10/2012 03:20, sumesh56 ha scritto:
hai everybody,
i have a column containing marks of students. say E4:E35.
the marks of individual students is in out of 90.
i need to calculate the class average of the marks in 100.
i used the following formula but excel gives me error.

=SUM(((E4:E35)/32))/90*100

help me plz. thanks. have a nice day.


+-------------------------------------------------------------------+
|Filename: MKLIST FOR EBR.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=620|
+-------------------------------------------------------------------+





=AVERAGE(E4:E35)/90*100

E.
thanks a lot for both Isabella and Plinius for the reply. very happy to find that both the formulas works for me. but can u plz explain where was the text occured in between the numbers which caused for the error?
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 51
Default percentage calculation

Il 14/10/2012 04:54, sumesh56 ha scritto:

thanks a lot for both Isabella and Plinius for the reply. very happy to
find that both the formulas works for me. but can u plz explain where
was the text occured in between the numbers which caused for the error?


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+




Removing unnecessary brackets, your formula is:

=SUM(E4:E35/32)/90*100

E4:E35 is not a single value dividing by 32 but a matrix, therefore it
is a matricial formula and can work correctly only if confirmed by
CONTROL+SHIFT+RETURN

Hi,
E.





  #6   Report Post  
Senior Member
 
Posts: 118
Default

Quote:
Originally Posted by plinius View Post
Il 14/10/2012 04:54, sumesh56 ha scritto:

thanks a lot for both Isabella and Plinius for the reply. very happy to
find that both the formulas works for me. but can u plz explain where
was the text occured in between the numbers which caused for the error?


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+




Removing unnecessary brackets, your formula is:

=SUM(E4:E35/32)/90*100

E4:E35 is not a single value dividing by 32 but a matrix, therefore it
is a matricial formula and can work correctly only if confirmed by
CONTROL+SHIFT+RETURN

Hi,
E.
thanks for the reply. have a nice day.
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
Percentage Calculation Chris Excel Worksheet Functions 7 September 3rd 09 12:36 PM
percentage calculation Gabriel Excel Discussion (Misc queries) 1 August 28th 06 09:31 AM
Percentage calculation Roz Excel Discussion (Misc queries) 5 January 6th 06 08:05 PM
Percentage Calculation using VBA Peter Excel Programming 4 November 7th 05 12:06 PM
Percentage Calculation clandis Excel Worksheet Functions 5 July 21st 05 07:38 PM


All times are GMT +1. The time now is 08:56 AM.

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"