The completed template can be adapted and expanded to meet your individual requirements.
In the design, I will make use of Excels IF Statements and employ the IFERROR command to correct formulae.
I also make use of the powerful Conditional Formatting Tool.