Hi all, I received help with this spreadsheet before and now have a new hurdle I'd appreciate your help with.

I am trying to find the correct formula that will populate a ranking (1, 2, or 3) based on specified ranges of a previous cell's value.

Three cells in a column come into play on this. The top cell is a simple SUM, the middle cell is averages the SUM criteria to provide a %, and the bottom cell that I'm having trouble with is supposed to generate a ranking based on where the middle cell's value falls within three ranges (0%-45% = 1, 46% - 67% = 2, 68% - 100% = 3). I have attempted several formulas, here is what I've landed on:

=IF(D17<=45, 1, IF(D17<=67, 2, IF(D17<=100, 3, 0)))

I originally thought this would work:

=IF(D17<=45, 1, IF(D17>=46, D17<=67, 2, IF(D17>=47, D17<=100, 3, 0)))

I'm receiving an error re: too many arguments for the latter formula. Now I'm stuck.

Thank you in advance, please let me know if I can provide any further info that may help!