Hi and welcome to the forum.

Come up with 4 separate formulas which calculate how each assignment contributes to the final grade. Put them in a worksheet together with some sample data and attach the workbook to this thread. We'll then be able to give you some guidance on how to combine together to a single formula.