mardi 15 août 2017

IF Statement nested in MEDIAN Function not generating list in Excel

I'm working on some statistics for some classes at my school. I'm trying to have a formula that will calculate the median of ratings for the different classes. My formula I have is:

=MEDIAN(IF(Table1[Class]="AR",Table1[Rating]))

But I can not figure out why the IF statement doesn't output correctly into the MEDIAN Function.

From what I understand, the IF statement should look through column A's list of classes and see if they are "AR", if they are, they should output that value, if not, then output nothing. (I am aware that the output of nothing is not possible and it will output 0.)

If anyone could help, that would be great!

Picture of Formula In Action

Excel File

Aucun commentaire:

Enregistrer un commentaire