Jul 30 2020 01:22 PM
Hello!
I need help creating the criteria for an average problem. The question is what should the formula look like: If a student expected to get the Final Average of 95, what would their Final Test score need to be?
Ex:
First Name: | Last Name: | Test 1 | Test 2 | Final Test | Final Average: |
ab | cd | 56 | 85 | 70 | 70.33 |
Any help and guidance would be most appreciated. Thanks! :)
Jul 30 2020 01:31 PM
@Sergei Baklan so would the criteria I would include all of those cells? OR just put in the formula as you have it?
Jul 30 2020 01:48 PM - edited Jul 30 2020 01:50 PM
Of course it's better to use cell references, like
=3*B6 - (B3+B4)
or more complex ones, depends on your file logic
Jul 30 2020 02:14 PM