Tiered Fee Formula Help

Originally Posted by Crooza

To hard code put the value from the respective arrays inside squiggly brackets

For example if A2:A5 is 0, 4, 5, 6 then replace this A2:A5 with this {0,4,5,6} and so on.

Give it a go. If you can't work it out let me know and I'll tidy it up for you

Got it to work, thank you so much!!!!