If on the final day of term the House Points are tied, when you talk to Hermione or Ron they will say that you definitely have enough House Points to defeat Slytherin, However, when you go into the Great Hall, Dumbledore will give the House Cup to Slytherin.