Cells not displaying result of formulas (F9 shows the correct result)

[NathanGMcG]

Hi There,

I've having trouble with what appears to be some kind of glitch. The formulas in the attached spreadsheet are not displaying the results of the formula, although the formula is definitely correct because the F9 evaluation yields the correct result. Can someone please take a look and see why this might be happening? I've googled across the web but no answers I've seen appear to solve the problem.

I'm also having a problem with circular references. Whenever I use the today() function, excel is deeming it a circular reference. Does anyone know why this might be?

Thanks for your help.


Nathan

 

[NathanGMcG]

Sorry, I realised you can't attach spreadsheets to this forum. How... unhelpful. I also can't find the delete function for this thread. Please ignore the question and I'll go elsewhere.