View Single Post
 
Old 12-07-2017, 04:11 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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
File Type: xlsx Copy of Prices with different breakpoint.xlsx (13.9 KB, 12 views)
Reply With Quote