If you have to round 0.5, do you think it should round to 0 or 1? I bet that you learned in school that it should round to
1. However, this will introduce errors. Episode 1046 talks about the errors introduced by this rounding.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!