I'm working on a spreadsheet in Excel. Column A is student's name. Column B is a placement test score. Column C is a benchmark score. Column D is an effort score. Column E is for a TOTAL score. How do I assign column B a weight of 20%, column C a weight of 50%, and column D a weight of 30% to give me a total for column E?
The formula for E should be
Parens may not be needed but should work. 

