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	$799.96
13-0801	blue	Seed	$6.99	34	$237.66
13-0820	green	Seed	$99.99	30	$2,999.70
14-1164	yellow	Sod	$5.15	15	$77.25
14-2311	green	Seed	$136.99	1	136.99
14-2344	blue	Sod	$2.85	52	$148.20
14-3252	red	Sod	$6.24	25	$156.00
14-8256	purple	Sod	$2.85	125	$356.25
15-5635	red	Sod	$7.09	45	$319.05
15-5636	green	Sod	$1.33	822	$1,093.26
16-2389	green	Sod	$4.82	15	$72.30
16-3881	yellow	Sod	$2.85	75	$213.75
16-4625	yellow	Sod	$1.01	38	$38.38
17-2850	blue	Sod	$2.95	127	$374.65
purple	purple	Sod	$3.10	22	$68.20
54-21133	Purple	Bulk Seed	$159.99	3	$479.97

For the data shown above:

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

In other words show how to use the data on the table to find the delivery column (use an IF function) and the "New price w/ 15% off" (Two Formulas Order total and New price w/ 15% off)

PLEASE PROVIDE FORMULA ON HOW TO GET THESE LAST 2 COULMNS AND ALSO A SCREENSHOT IF DOABLE!