IF Statement for Sales Spreadsheet

[SkzDaLimit]

Greetings! I need a quick formula to throw into my sales spreadsheet that will adjust a cell value on a Yes or No statement.

Excel Workbook
	A	B	C	D
1	Sale Price	FVF		Power Seller? Yes/No
2				Yes
3	$12.99	$0.78
4	$13.25	$0.80
5	$15.66	$0.94
6	$14.59	$0.88
7	$7.87	$0.47
8	$19.24	$1.15
9	$16.75	$1.01
10
11	$100.35	$6.02
12
Sheet1

Excel 2003

B11 is the cell that this adjustment will apply to. Basically if cell D2 = Yes, then then value of B11 should be the SUM(B3:B9) and then a 20% discount applied to that total (in this example the discount would be $1.20 and the value of B11 would be $4.82. If D2 = No, then B11 remains unchanged at it's current value of $6.02.

I keep getting a circular reference when I try writing an IF statement..... Thanks for all the help.

 

[Jonmo1]

Try

=SUM(B3:B9)*(1+(D2="Yes")*0.2)

 

[SkzDaLimit]

Try

=SUM(B3:B9)*(1+(D2="Yes")*0.2)

Worked like a charm! Thanks so much!