I am struggling to write a set of formulas that produce the results in the attached spreadsheet and is based on the highlighted number entered. It should calculate the tiered cost for any number entered up to 200,000. I feel sure there is a concise and advanced set of formulas that will achieve the results, but I cant get there. I will need to use the logic quite often going forward.
Your help is greatly appreciated.
The corresponding Excel workbook is attached.