When the forces acting on an object cancel out - the resultant force is zero.
When the forces acting on an object are balanced the object will either be stationary or be travelling at constant speed.