This is the current formula we're using and, minus one small snag, it's working:
=MEDIAN(Name1!D24,Name2!D24,Name3!D24,Name4!D24,Name5!D24,Name6!D24,Name7!D24,Name8!D24,Name9!D24,Name10!D24,Name11!D24,Name12!D24,Name13!D24,Name14!D24,Name15!D24,Name15!D24,Name16!D24)
This is a formula for determining the average grade and inputting everything into a report card. The problem is that with the curriculum in Ontario, any mark that falls below a 30% receives an "IE" (Insufficient Evidence) on their report card. Technically, an IE = 0%, but because of ministry standards, we aren't able to do that on a first term report card.
So when we enter "IE" into one of the D24 cells, the overall median doesn't change - essentially it takes IE to be an invalid amount and therefore has no effect on the Median formula.
I'm wondering if there's a way to put into the formula that "IE=0" so that when IE is put in, the median adjusts accordingly.
Thanks,
Ryan
Bookmarks