Nested IF statement formula error

[BoggleJ]

So I am trying to make commission calculator based on my job at work and I used a table for the tiers we get paid out on for sales. I am trying to make a nested if statement that if a criteria is met is uses a cell on that table and loops through criteria until one is met to determine the tier you would get paid out on. My formula currently is =IF('Lead Sheet'!AE11 <= K2, 22, IF('Lead Sheet'!AE11 <= K3, 27, IF('Lead Sheet'!AE11 <= K4, 38, IF('Lead Sheet'!AE11 <= K5, 42, IF('Lead Sheet'!AE11 <= K6, 48, IF( 'Lead Sheet'!AE11 >= J7, "25", IF "53"))))))

Column AE is sales for the month on another sheet

 

[Toadstool]

Hi BoggleJ,

There may be an easier solution using your table directly. Please take a look at this solution:
How to Get a value from a table range