Hi, this is my first time posting and I would really appreciate some help. I am quite a basic excel user and am really struggling to create the formula I need!

I am trying to calculate commissions which are paid at varying rates depending on the number of sales.

If the number of sales is less than four, £0 is payable.
If the number of sales is 4 - 5, they are all payable at £4 each
If the number of sales is 6 - 9, they are all payable at £6 each
If the number of sales is 10 or more, they are all payable at £10 each
(The number of sales is totalled in cell H25)

I have been going round in circles for hours and can't quite seem to pin the formula down. Any help would be greatly appreciated! Please ask if I haven't explained what I need very well. Thanks in advance!