I’m currently working on a 37x37 matrix filled with values between 0 and about 250. Most of these values are = 0, but I’m interested in calculating the first and third quartiles + the median of the non-zero values.
My approach was to include the IF-Function in the argument like this: =QUARTILE(IF(C9:AM45>0;C9:AM45); 1) where C9:AM45 is my matrix and 1 stands for the first quartile. Unfortunately it only returns “#value!”.
Has anyone suggestions on how to correctly apply this condition of >0 in the quartile-function?
Many thanks in advance!