Product IF Function

Try this...

Data Range

	A	B	C	D	E
1	Rebate	2%	------	Rebate	0.00150%
2	Rebate	1.50%
3	Discount	3%
4	Discount	2%
5	Rebate	5%

This array formula** entered in E1:

=PRODUCT(IF(A1:A5=D1,B1:B5))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Format as Percentage to as many decimal places as you want.