Need Help with Formula to Grade Assessment Test

Good evening,

Basically, there are 3 assessment test that potential employees need to take and pass to the next level. The test score parameters are as follows:

Any score >= 90% is a grade 3. Any score >= 80% is a grade 2 and lastly any score < 80% is a grade 1.

I want my formula to say as an example : If an individaul gets 90% in one assessment, 100% in the second assessment and 91% in the last assessment then my formula results should be 3. Because in all three assessmet the lowest percental is above 90%

However, if they score 90% in one assessment, 100% in the second assessment but 79% in the third assessment my formula results should be 1. Because in one of the assessment they score below 80%. So the formula should always reference the lowest percental.

Another eg. If they had 100% in first assessment and 90% in second assessment but 89% in the last assessment, formula results should be 2. Because in one assessment they scored below 90%(lowest percental) but the other 2 assessment were above or equal to 90%.

Thank you.

you could use a MIN

IF( Min ( rows/columns with grades in) < 80% , 1, IF( Min ( rows/columns with grades in) < 90%, 2, 3))

You saved a life today.

Thank you

Thank you very much.

Thank you too Andy.