Thank you so much...
That seems to be exactly what I need!!!
Thanks again


"Bernd P" wrote in message
oups.com...
Hello Grace,

Array-enter (enter with CTRL + SHIFT + ENTER, not only with ENTER)
=A1*PRODUCT(1-B1:F1%)

Unused discount cells should be deleted or filled with 0 (zero).

Regards,
Bernd