Hi all.
I guess that it was already discussed but I cannot find them.
There is a table:
# Ref € Ref BreakPoint €
A 1 10
A 5 9
B 1 1
B 14 0.2
When you buy 2 units of the reference A the price is 10€
When you buy 8 units of the reference A the price is 9€
What formula should I use to have automatically the right price when I put the reference and the quantity?
Thanks