Thursday, 27 October 2011

Excel can't do maths

I stumbled upon a little publicised bug in the current version of Excel whereby it displays the wrong trend line equation on scatter graphs.

You would expect such a simple and often used function to work but apparently not. I only discovered this after someone tried to use the equation I'd presented to them and complained that it was wrong!

The lesson I've learned is to always double check my maths, regardless of whether I had 'help' from a computer.