The Discount amounts in cells D4, D5, D6 and D7 are computed using the IF function. The discount amoun in colum D should equal the Discount % from the assumptions area multiplied by the Sales figure from the column B if the corresponding Sales in column B is greated than or equal to $300,000. If the corresponding Sales in column B is less than $300,000, then the Discount amount is calculated us 5% as the discount percentage. The IF function in cell D4, D5, D6, and D7 are incorrect. Edit and correct the IF function and show formulas.

WheelsAboutTown.com Annual Projected Net Income
Contract	Sales	Transportation Costs	Discounts	Maint. Costs	Net Income
Media Outlets	$350,124.50	$32,211.45	$42,014.94	$29,760.58	$246,137.52
Publishers	267,543.95	$24,614.04	13,377.20	#REF!	#REF!
Financial Consortium	642,245.50	$59,086.59	77,069.46	-	506,089.45
Downtown Hotel Core	456,955.25	$42,039.88	54,834.63	#VALUE!	#VALUE!
Total	$1,716,869.20	$157,951.97	$187,296.23	#REF!	#REF!
Assumptions
Transportation %	9.20%
Discount %	12.00%
Maint. Costs %	8.50%