tommytowbar
wrote in :
excellent work !
thanks for that
no more sleepless nights
I'll echo George's previous comments. Maintaining the discounts in a
separate table is the way to go.
There are a few ways to get the needed discount from the table. I prefer
INDEX & MATCH, VLOOKUP is also popular.
-RP