Finding Mid Score

  • Thread starter Thread starter lacosta
  • Start date Start date
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.
 
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?
 
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

Lookup Question 3
Help with Time Distribution Formula 2
Conditional Formating Issue 1
Need help adding a formula to to cell with conditional formatting 3
Help With Formula For Cell Addresses 2
Easier way to concatenate a row? 8
Trouble with skipping rows 1
Stair-step commissions question 2

Back
Top