Is there a better way to optimize If formulas?

So I was tasked to make a workbook to help a team leader track the problem projects of his members. In this sample, I only used two formulas (columns G and H). My question is how should I optimize th...