"Harlan Grove" skrev i melding
oups.com...

You could, but why would you want to use it rather than

=SUMPRODUCT(--(A1{2500;5000;10000;20000;35000;50000;70000;10000 0}))

Hi Harlan
I always needed to treat each TRUE differently, as in the discount sample I
posted. This posting was for educational purposes though, I think one must
understand my solution to be able to understand its Sumproduct equivalent..

Best wishes Harald