Did you try Ctrl + Alt + F9?
--
C


"Intellihome" wrote:


Hello every one!

I have a problem with how cells are being calculated.

I have formulas, which contain nested If statements. They are all the
same in one column, except they are referencing corresponding rows as
usual.

Well the problem is, I do one change on the worksheet and those
formulas throw me a #VALUE. I go to the "Trace calculation", and trace
every step of the calculation of the formula, it works perfect up to
the very last step. If the last trace step looks like the following
example:
=if(FALSE,#N/A,{345.45648})
then I can see that up to this point every nested statement was
calculated correctly and IF function is ready to return a result
{345.45648}, but instead it throws #VALUE.

If I click on the cell with this formula and the click in the formula
bar and hit ENTER, then it returns a correct result.
Pressing F9 does not help.
Copying formula down - helps.
Pressing just ENTER on that cell - does not help.
Reloading Excel - helps.
The thing is if I get 1000 cells I do not want to reload Excel or
copydown formula all the time or eveen worse to hit ENTER while cursor
is in the formula bar.

Any ideas will be greatly appreciated!
Ivan.

Hey I just figured WHY it happens, BUT still I do not have a clue how
to fix it.
It happens when I make such a change when formula WOULD return #VALUE,
but then when I change it back when a formula SHOULD NOT return #VALUE,
it still returns me #VALUE. It is like it never goes back to normal once
it gets to #VALUE.


--
Intellihome
------------------------------------------------------------------------
Intellihome's Profile: http://www.msusenet.com/member.php?userid=1479
View this thread: http://www.msusenet.com/t-1870563681