To clarify, I have attached part of spreadsheet, based on the pricing bands, how do I 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.
Thanks

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