The reason for the discrepancy seems is the Excel quirk referred to in the sidebar (in both the printed and e-book book) and at point 03:08 in the video.
If you look closely at the video, I show the "wrong way" first (and then explain why this won't work). When I replace the incorrect formula you can see that I make an error and don't actually paste it into the formula bar so the formula remains at: =D28 instead of the correct formula stated in the video and also in the text book/e- book that is =(C28*0.5+1.5)/100.
This has had exactly the effect described and placed incorrect values into the table.
I must commend you on spotting this. The video has been viewed over a million times and you are the first to notice my mistake.