percentage calculation
1 Attachment(s)
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. |
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| +-------------------------------------------------------------------+ |
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. |
Quote:
|
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. |
Quote:
|
All times are GMT +1. The time now is 08:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com