Forum Discussion

Warren Bartram's avatar
Warren Bartram
Copper Contributor
Mar 11, 2018

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. 

 

I havent had any luck for some reasoning finding it but will appreciate any help provided! 

 

Thanks in advance :) 

excel
  • Jamil's avatar
    Jamil
    Bronze Contributor
    Mar 11, 2018
    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.

Resources