Based on the pricing bands, I would like to khow how to input an amount of sales in the highlighted cell (B6) and automatically calculate an amount to charge in the cell below (B7)?

Hope you can help.
Many thanks

PS Don't seem to be able to upload excel files due to small flle size so hope this notepad file will suffice?