This does not work - the value at J6 changes and when it went up to 145 with the formula you provided it gave me a figure of 3.5 but the value it should still return is 3.
Manual calculation of quantity at 145 in stock is 2.9 (value divided by 50) then rounded up answer should return the number 3
Bookmarks