Hi I am struggling with what should be a straight forward sales / recompense calculation.

G is my variable "opportunities found" column where I imput the no. found per week.
I wish to change from a flat 8$ per opportunity to have a tierd increasing return.
so upto 30 pays $8 each then between 30 to 60 pays 10$ each and any over 60 pays $14.95
At moment I have =SUM(G12*8) for the flat result - Any help appreciated!