Thread
:
discount formula help
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
Bernd P
external usenet poster
Posts: 806
discount formula help
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
Reply With Quote
Bernd P
View Public Profile
Find all posts by Bernd P