Median If Function

  • Thread starter Thread starter allyrose79
  • Start date Start date
A

allyrose79

Hi!
I am working on a statistics report, and I need to find the median of a
percentage increase, decrease, and no change. Would these be the formulas I
need to use?

=MEDIAN(IF(C160:CI160,">0")) for increase
=MEDIAN(IF(C160:CI160,"<0")) for decrease
=MEDIAN(IF(C160:CI160,"0")) for no change

Thanks so much for your help!
~Allison
 
Try

=MEDIAN(IF(C160:CI160>0,C160:CI160))

etc., which is an array formula

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar' you can notice the curly
braces at both ends like "{=<formula>}"

=MEDIAN(IF(G1:G20>0,G1:G20))
=MEDIAN(IF(G1:G20<>"",IF(G1:G20<0,G1:G20)))

If this post helps click Yes
 
No. You need to remind yourself of the syntax of the IF function; look it
up In Excel help.
The first argument should be a condition, and the second is the outcome if
the condition is satisfied. Remember also that a string enclosed in quotes
is text, so it wouldn't be any use as an argument for a number function like
MEDIAN.
 
Back
Top