Hello! I have been working for more than 2 days to try to figure this out and asked others for assistance who could not either.

I need a calculation for the following: There are 2 factors in this to consider. To score 80% of the total points, you must get a score of 90-100% of the total reviewed for one factor and 60-89% or the total reviewed for the other factor.

For example: The total points for this example is 4. If 100 files are reviewed, to score 100% of the total points, 90-100 (90-100%)of the files reviewed must have met the criteria in one factor, and 60-89 (60% - 89%) must have met the criteria in the other factor. The 60%-89% cannot be more than 89% or less than 60% - that would put it in a different category.

Factor 1: score = 85%
Factor 2: score = 92%

Final score: 4 x .8 = 3.2

If it doesn't fulfill this, then "0"


Then to throw a kink into this whole thing, if cell x = "ERROR","ERROR"

I tried every kind of nested IF statement, IF(AND, IF(OR, IF(OR(AND, etc. I finally gave up and put each part in 3 different columns and then just did a sum (which, btw, wouldn't work if I did =SUM(x:y) but if I did =x+y it would work - sigh).

Can anyone help to make this one equation? Thanks!!!