Nested IF with multiple calculations

Hi Everyone

New to this Forum.

I need to calculate the following:

I have weights that have certain prices attached to it, i.e. if the weight in C4 is greater than 1000, then I multiply the cell by the cost in B9 but then I still need to work out how much the cost would be i.e. if its 150 kg then I need to multiple the result from my nested if to get the cost for 150 kg.

=IF(C4>1000,$B$9*7.23,IF(C4>500,$B$9*7.54,IF(C4>300,$B$9*7.86,IF(C4>100,$B$9*8.3,$B$9*9.2))))

How do I do this?

Help would be wonderful.

Thanks

Kim