Finding Mid Score

L

lacosta

I have 3 colums with different scores in the same row. I want to creat
a formula that will give me the mid score for the 3 columns. Also th
mid score has to be above 640. Please help :confused
 
A

Alex Delamain

=if(large(a1:c1,2)>=640,large(a1:c1,2),"Too small")

=large(array,k) picks the kth biggest value. Ie if k=1 it picks the
biggest, if k=2 it takes the second biggest etc
 

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

Drop down list control value in vba 2
Force Distribution/ Force Ranking for Bell Curve 1
return multiple values when within range (greater than and less than) 11
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Average with criteria for adjacent cells ? 1
Scoring a result in a cell 4
Lookup multiple cell values and place contents in a single cell 3
Sports question. Finding points scored by specific team 2

Top