Average Formula HELP! :)

Copper Contributor

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 1Test 2Final TestFinal Average: 
abcd56857070.33

Any help and guidance would be most appreciated. Thanks! :) 

5 Replies

@meguernsey 

I guess =3*95-(56+85)

@Sergei Baklan so would the criteria I would include all of those cells? OR just put in the formula as you have it?

@meguernsey 

Of course it's better to use cell references, like

 

=3*B6 - (B3+B4)

 

or more complex ones, depends on your file logic

@Sergei Baklan Thank you so much!!!!!

@meguernsey 

 

I trust we can safely assume you're not a math teacher... (smiley face)