jeudi 16 janvier 2020

Check two columns to see if a pair of elements are both greater than separate minimums?

I use Google Sheets to track my student's reading speed and comprehension scores. They have a goal to increase their reading speed N% over the semester, but that speed will only be accepted if they also get a minimum score on their comprehension questions. The speed is recorded in one column, and the corresponding comprehension score in the column next to it.

I want to write a Google Sheets function that will check the two columns of numbers and tell me if the reading speed is above their goal AND the comprehension score is above the minimum.

For example, let's say the student's reading goal is 202 wpm with a minimum acceptable comprehension score of 5. Given the following reading speeds and scores, the first three rows would not meet the goal since either the speed or comprehension score fail to meet the minimums. The fourth row would be the first to produce a positive result.

Speed   Score
 - 171 | 6
 - 205 | 4
 - 200 | 6
 - 206 | 7
 - 210 | 6

I've banged my head against this one, but I keep running into trouble. Any help would be appreciated.

Aucun commentaire:

Enregistrer un commentaire