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
Column AE is sales for the month on another sheet