Excel formula not evaluating

I am facing a rather quirky issue with some of the excel formulae. In a few cells, the formula is not getting evaluated. It is showing the formula text instead. The formula evaluation tool shows "the...