The formula for the next quantity/price above if no match is a lot easier than what your sheet is expecting (seems like it is expecting an interpolated value since 666 is in between the value above and below the one you specified. Can you confirm which one you actually want?
Bookmarks