Thread: Price with different break points
View Single Post
 
Old 12-07-2017, 06:52 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
Here is my solution applied to your original data... test it.

Maybe you didn't change the commas in my formula to semi colons to accomodate to your Excel version?
Attached Files
File Type: xlsx Copy of Prices with different breakpoint.xlsx (9.2 KB, 11 views)
Reply With Quote