can someon help me build a tiered pricing calculator in excel?
basically, I need something where I can experiment, say 50 terminals total, and then I can set up 1-10 = 100%
11 - 20 = 75%
etc.
it should be non-regressive
and tell me total revenue, revenue per % tier and NET % discount rate
I have attached what I have thus far but need to manipulate the % levels that will then reflect against the %discount, also when I modify the A1 cell to say 11 total terminals it does not calculate correctly. Can someone help!! Thank you


upload.pngPrice Table For Tom.xlsxbut I need to be able to adjust seat & percentage numbers