goal reward in excel

Greetings, I am trying to do the following on the table below; A student has two goals in each lesson. Goal one is a number (grade) and the other goal is a percentage. A user can type in cel...