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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLookup IF word in string exists within cell, use the word. 0
Help With Formula For Cell Addresses 2
Conditional Formating Issue 1
Help with Time Distribution Formula 2
Median If Function 3
Easier way to concatenate a row? 8
Summing 2 columns based on variables 3
Excel 2007: Vlookup Problem 5

Top