Column A, cells A1, A2 etc have values in it. i.e.
525000
675000
etc.
In cell B1, B2 etc I need to know how to get 7% of the first 100,000 and 2.5% of the remaining amount
I.E
525,000, 7% of 100,000 plus 2.5% of 425,000
675,000, 7% of the first 100,000 plus 2.5% of 575,000
I can do it in two...