Ranking weighted scores with partial results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to rank a series of results with each result having a weighted
value. My dilemma is what do I do if there isn't a result listed and I do not
want that to negatively impact the overall ranking?

Weighting (results in b1:b3)
Result 1 - 30%
Result 2 - 20%
Result 3 - 50%
= 100%

a1:a3 are locations
b1:b3 are results
c1:c3 I'm using this formula to weight the results...=IF(b1=0%,"
",SUM(b1*.30))
b2 has a 0 result though. how do I create a value there without having a
result listed? What would that formula look like? And is this even possible?
 
The answer depends on what you want to do if something is blank as far as the
rest of the weighting is concerned. If C2 should still have a .2*B2 formula
then there is nothing you need to do.

FYI - the formula should be =IF(B1=0,"",B1*.3)

No need to us the SUM function.
 

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

Weighting Results to obtain an overall rank 1
How to use autofilter in excel with formula reference changing 1
Percentages breakouts for Ranking 1
How do I calculate a weighted average and exclude the empthy cells 2
concatenate with arrays 4
Scoring Rank with Tie Breaker 4
multiplication of two array in a particular way 2
Baffeling IF statement 7

Back
Top