Order #	Product	Category	Price Per Unit	Units Ordered	Order Total	Delivery	New price w/ 15% off
10-1312	Blue	Bulk Seed	$144.99	6	$869.94
10-1326	red	Bulk Seed	$199.99	4
13-0801	blue	Seed	$6.99	34
13-0820	green	Seed	$99.99	30
14-1164	yellow	Sod	$5.15	15
14-2311	green	Seed	$136.99	1
14-2344	blue	Sod	$2.85	52
14-3252	red	Sod	$6.24	25
14-8256	purple	Sod	$2.85	125
15-5635	red	Sod	$7.09	45
15-5636	green	Sod	$1.33	822
16-2389	green	Sod	$4.82	15
16-3881	yellow	Sod	$2.85	75
16-4625	yellow	Sod	$1.01	38
17-2850	blue	Sod	$2.95	127
purple	purple	Sod	$3.10	22
54-2113	purple	Bulk Seed	$159.99	3

For the data shown above:

1. One IF function ( for the delivery column) - order totals of $300 or more receive free delivery, otherwise $50 for that delivery. Also how to conditional format for the word free.

(Just would like the formula on what to use). Please just do one example with the numbers from above for order number 10-1312