An working example is in attached file. I changed the starting break-points from 1 to 0, and in formulas added a calculated MAX break-point value as 999999 (it may be any value Excel can interprete as number, and which is bigger than any real break-point you may have).

I left the reference untouched, but really you can use fruit names instead directly.

Attached Files

Copy of Prices with different breakpoint.xlsx (13.9 KB, 12 views)