There are a few variables at play. I would like to incorporate a sliding scale for a student's high school gpa that looks like this:
Students GPA: SAT Score ACT Score
2.00 1010 86
2.025 1000 85
Students GPA=Combo Box1
Combo Box2=(If GPA=2.022, event.value=1010/86)
Combo Box2=(If GPA=2.028, event value=1000/85)
and so on (the scale continues on up to GPA=3.525
How would I calculate that?
Thanks for your help
Retrieving data ...