Excel error - doesn't give correct answer

[cpis0002]

Hi,
This has happened to me more than once, and is extremely annoying of excel, hehe.

Basically, a formula doesn't give the correct answer. I have used the Evaluate Formula tool... and it breaks it down to a very simple addition and still gets the answer wrong.
That is: a few weeks ago, I had this problem... I did evaluate formula... and it came down to '=6+3'... and the answer it gave was '0'

Today, I am using this formula:
=IF(First="Yes",IF(Y795>=0,"Retained earnings","Accumulated losses"),IF(AND(W795>=0,Y795>=0),"Retained earnings","Accumulated losses"))

Using the Evaluate Formula Tool, I get:

=IF(FALSE,#N/A,"Retained earnings")

... so the answer should be "Retained earnings"... but it gives me '0'


Does anyone know why this happens?

The exact formula is used a few lines down and is based on exactly the same cells, and it gives the correct answer. Just sometimes, excel refuses to work on certain cells.

One way I found to fix this is by going on Tools, Options and increasing the iterations... but this may cause more problems due to future circular references.

Thanks for your help,
Chris