how to calculate if amount is over or = too to add a percentage

HI All I am working on an assessment and the question is  Calculate the Qtr Commission of the Qtr Sales Total using the % rate in H8 I have tried the VLOOKUP, SUMIF and IF calculations none are wor...