Calculating Commission Total

Would like to add formulas that automatically calculate commission based on lead types. For example, self generated leads = 7% commission vs open leads = 5%

When the total bill is submitted I would like for commission to be calculated based on the job total x the % value dictated by the type of lead

I’ve done it in excel, just need help with conditions in this system