I need a spreadsheet updating with formulas that allows the quick evaluation and comparison of subscription and transaction fees for online payment gateways.
The data required is pretty much all there in the sheet but requires to be more dynamic, the following currently exists in the sheet: update order quantity and average spend and it calculates the daily. monthly and yearly costs/spend associated with it.
Some of the data field operate on a sliding scale, i.e. average spend between 0-1500 = 2%, between 1501-5000 = 1.4% etc. This part needs to have a formula to calculate automatically.
The option to add additional providers and values will be required.
I need this in the few couple of hours.