Formula help

[foreverunitedri]

https://imgur.com/a/WsMJj

Hi all,

Above is a screenshot of the sheet that I am using to calculate payments.

I want to put a formula in B13 that automatically works out the weekly fee that each client has to pay.

The weekly fee is determined by the total number of orders (cell B4) and you can see in cells AB17 to AB24 how much the fee is dependant on the number of orders.

Would someone please be able to share what I need to input?

Thanks in advance.

 

[ljubo_gr]

On IMGUR.COM click on your picture to get share link, then copy share link, then on mrexcel InsertImage....

 

[foreverunitedri]

 

[foreverunitedri]

Here we go, thanks.