Finding Mid Score

L

lacosta

Never Mind my last email. If figured it out. This is what I did.

=IF(MEDIAN(S2:U2)>=640,MEDIAN(S2:U2),"0")

Thanks.
 
F

Fred Smith

Glad you found a solution. But why use "0" when the median is less than 640.
Why a text value. Why not just 0. Wouldn't that be easier to work with?
 
Top