Q: Formula for Free Delivery over $45 Home Depot Items

A: You could create an additional formula for Home Depot which would be as shown below. Any items that you want to use this additional formula must not be overridden.  They must be set to use whatever formula you have in your default marketplace settings (which is a split range formula). That selling price would be calculated based on supplier price and then the result of this additional formula below would be added to that selling price. So for example, if the shipping is $5.99, then an additional $2.995 would be added to your calculated selling price, and then it would be rounded to the nearest cent naturally.

abs(((((vendor_price-44.995)+abs((vendor_price-44.995)))/2)/(vendor_price-44.995)-1))*((vendor_shipping/2))

Here's a video for more information on using Additional Formulas - https://www.youtube.com/watch?v=by95D9Ipz_0

After you add your additional formula, you'd need to make sure that none of your items have override formulas.  If you know that they already don't you can ignore this, but if you are unsure, then please go to Batch Options --> Remove All Per Item Formulas.

Then regardless, you would need to force reprice/force update your items by going to Batch Options --> Force All Items to Update.