In cell H6, use the IF function to create a formula that will subtract $50 from the cost of the instrument on the same row is percussion, and will return the full cost if it isn’t percussion.

That i would call a dead end, since you can't know that it's always possible to immediately reconnect (server could be down, lines between you and the server could be down), and even if it was this would take some time slipping the packages out your wan in the meantime.the solution to this problem rather like satras says to block wan access for those hosts, and if policy routing is being used you need to use the soltion found by fastlanejb in this thread:   the link to the problem forum 

See the circle pic of you in the right corner, click on it! i will say view profile, edit profile, log out. click on edit profile. then, click on change pro file pick. you can browse to see which picture you !