Average Formula HELP! :)

%3CLINGO-SUB%20id%3D%22lingo-sub-1557173%22%20slang%3D%22en-US%22%3EAverage%20Formula%20HELP!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1557173%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%26nbsp%3B%3CBR%20%2F%3EI%20need%20help%20creating%20the%20criteria%20for%20an%20average%20problem.%20The%20question%20is%20what%20should%20the%20formula%20look%20like%3A%20If%20a%20student%20expected%20to%20get%20the%20Final%20Average%20of%2095%2C%20what%20would%20their%20Final%20Test%20score%20need%20to%20be%3F%26nbsp%3B%3C%2FP%3E%3CP%3EEx%3A%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22617%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22101%22%3EFirst%20Name%3A%3C%2FTD%3E%3CTD%20width%3D%22112%22%3ELast%20Name%3A%3C%2FTD%3E%3CTD%20width%3D%22101%22%3ETest%201%3C%2FTD%3E%3CTD%20width%3D%22101%22%3ETest%202%3C%2FTD%3E%3CTD%20width%3D%22101%22%3EFinal%20Test%3C%2FTD%3E%3CTD%20width%3D%22101%22%3EFinal%20Average%3A%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3Eab%3C%2FTD%3E%3CTD%3Ecd%3C%2FTD%3E%3CTD%3E56%3C%2FTD%3E%3CTD%3E85%3C%2FTD%3E%3CTD%3E70%3C%2FTD%3E%3CTD%3E70.33%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EAny%20help%20and%20guidance%20would%20be%20most%20appreciated.%20Thanks!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1557173%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1557192%22%20slang%3D%22en-US%22%3ERe%3A%20Average%20Formula%20HELP!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1557192%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F745279%22%20target%3D%22_blank%22%3E%40meguernsey%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20guess%26nbsp%3B%3D3*95-(56%2B85)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1557198%22%20slang%3D%22en-US%22%3ERe%3A%20Average%20Formula%20HELP!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1557198%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bso%20would%20the%20criteria%20I%20would%20include%20all%20of%20those%20cells%3F%20OR%20just%20put%20in%20the%20formula%20as%20you%20have%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1557239%22%20slang%3D%22en-US%22%3ERe%3A%20Average%20Formula%20HELP!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1557239%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F745279%22%20target%3D%22_blank%22%3E%40meguernsey%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOf%20course%20it's%20better%20to%20use%20cell%20references%2C%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3D3*(B3%2BB4)-B6%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eor%20more%20complex%20ones%2C%20depends%20on%20your%20file%20logic%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1557246%22%20slang%3D%22en-US%22%3ERe%3A%20Average%20Formula%20HELP!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1557246%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you%20so%20much!!!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1557276%22%20slang%3D%22en-US%22%3ERe%3A%20Average%20Formula%20HELP!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1557276%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F745279%22%20target%3D%22_blank%22%3E%40meguernsey%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20trust%20we%20can%20safely%20assume%20you're%20not%20a%20math%20teacher...%20(smiley%20face)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

@meguernsey 

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

Highlighted

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

Highlighted

@meguernsey 

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

 

=3*B6 - (B3+B4)

 

or more complex ones, depends on your file logic

Highlighted

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

Highlighted

@meguernsey 

 

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