Average for Grade
No, I meant what formula returns A, B, C etc and the Div/0
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Param" wrote in message
...
=average(A1:A5)
*actually I really dont know how to create formula for this question.
TQ
"Bob Phillips" wrote:
What is your average formula?
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)
"Param" wrote in message
...
Hi,
How about this:
from cell range A1:A5 contain grades (link from another sheet).
example:
B
C
D
DIV/0
DIV/0
Question: because there is div/0, my average formula doesnt work. how
to
solve it?
TQ
"Bob Phillips" wrote:
Maybe something like
=LOOKUP(AVERAGE(IF(A1:A1000,A1:A100)),{0,50,60,70 ,80,90},{"F","E","D","C","B","A"})
as an array formula
HTH
Bob
"Param" wrote in message
...
Hi, I use below formula for marks(numbers)
For values in A1:A100
B1: =SUMIF(A1:A100,"0",A1:A100)/COUNTIF(A1:A100,"0")
OR
ARRAY FORMULA*
B1: =AVERAGE(IF(A1:A1000,A1:A100))
My Question: How to modify this formula for grade?
|