Hi all,

I'm trying to reverse the lazy caterer's sequence to determine which level of a number is closest.
1 1 1
2 2 3
3 4 7
4 7 14
5 11 25
6 16 41
7 22 63
8 29 92
9 37 129
10 46 175
56 231

EG:
175 is level 9 but what is the formula to return the number 9? (And yes the previous "cost" is required to get to that level (129 + 46 = 175))

I'd love to be able to get this into a single formula without the need for numbers in other rows etc. But I'm not sure that's possible.

The end goal is to have a number say 182 and return or tell us the MAXIMUM level you could get to. (9) And the remainder on a different cell. (not as important)