Finding Mid Score

  • Thread starter Thread starter lacosta
  • Start date Start date
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
 
=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
 
You must log in or register to reply here.

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

Sports summary sheet - think I put this in wrong place originally 1
I need help creating a score sheet with weighted values. Help Plea 2
Scoring a result in a cell 4
Lookup multiple cell values and place contents in a single cell 3
Finding Average of last 5 entries 11
Top 4 scores in excel 4
Adding or to previously provided Average If Array function 4
how do I use array references in VLOOKUP()? 2

Back
Top