Forum Discussion
Help with a table
Hello John,
I misunderstood your question. Now, I get it ;-)
What you need is a simple table with helper column and SUMPRODUCT Function.
Formula in F3 is =SUMPRODUCT(--($F$2>$A$2:$A$6),--($F$2-$A$2:$A$6),$D$2:$D$6)
you could set up a table like the one I have attached.
you can achieve your desired calculation using simply VLOOKUP formula and while many users may not be aware of VLOOKUP approximate match feature which is very handy for such calculations.
please see attached file.
Thanks for your speedy response Jamil, however, what I want if the facility to put an amount in F2 and for the spread sheet to calculate the overall charge.
So, for example, if the amount is £130,000 the calculation would be:
£25,000 @ 0.50% = £125
The next £75,000 @ 0.35% = £262.50
The next £30,000 @ 0.30% = £90.00
And then a total at the bottom i.e. £477.50.
Thanks
John