Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
|
|||
|
|||
Quote:
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentage Calculation | Excel Worksheet Functions | |||
percentage calculation | Excel Discussion (Misc queries) | |||
Percentage calculation | Excel Discussion (Misc queries) | |||
Percentage Calculation using VBA | Excel Programming | |||
Percentage Calculation | Excel Worksheet Functions |