Posts

Showing posts with the label Hemant Ganjre

Is MS Excel calculating it correctly?

* City Maths teacher finds that MS Excel software calculates ‘wrongly’ the factorials of numbers greater than 20, advises not to use the software with blind faith Staff Reporter The software giant Microsoft appears to have left a blind spot in the widely used product MS Excel. A city-based Mathematics teacher Hemant Ganjre has found out a problem with the software, and has advised users not to use MS Excel with blind faith while doing calculations. Ganjre told ‘The Hitavada’ that MS Excel’s versions of 2003, 2007, 2010, and 2013 calculate ‘wrongly’ the factorials of numbers greater than 20. “This is a very big mistake and cannot be neglected as factorial or FACT function is used for higher studies,” he said. Ganjre, who also teaches Vedic Mathematics, said that he found out the problem with the software from the number of zeroes at the end of the factorials calculated by using the software and calculations done manually. MS Excel is widely used software. It has many fun...