On Sun, 14 Jul 2013 00:55:00 +0100, Mark74w1 wrote:

Why is this formula not working even when excel corrects it?

What do you mean by "not working"?
Returns an error? If so, what is the error?
Causes Excel to crash?
Returns an incorrect result? If so, what is the original data and what is the returned result? (This might be more easily transferred by posting a workbook on some accessible site (e.g. Skydrive) and posting a link here.