View Single Post
 
Old 11-29-2019, 04:14 AM
abc3132 abc3132 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Feb 2015
Posts: 24
abc3132 is on a distinguished road
Cool Multiple criterias search in a table

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
Reply With Quote