Forum Discussion
Trying to find formula
I have been looking on google for a while to try find a formula to calculate numerous tiered amounts (as per screen shot) which calculates tax rates by the first $ amount and % then the next tier.
...
is it possible to upload the sample dummy file? you can use VLOOKUP's approximate match option to do this. I can give your the formula, if there is a sample file.