Excel Ninjas,
I need to calculate the amount of increase based on a sum obtained from previous cells. The rate of increase is dependent on the value of the figure from a given cell, e.g.K5.
The rate table looks something like this:
Col. A Col. B Amt. Col. C Increase on Amt. Col...