Hi Ford,

Thanks for the quick reply! Unfortunately, that formula is indeed too simplistic...
Column A would be the identifier. The type of discount (Column A) could be varied depending on customer contractual agreements.

I guess what's not explained here is that there is a Column C which details the specifics of Column A (e.g. prompt payment discount, volume discount...etc.). The type of discount could then vary depending on customer contract.

Hope this explains myself better?