Jax wrote:
I am seeing the following
A5: displays a value of zero(0)


In the status bar are you seeing "Circular" or "Calculate"?

If there is a circular reference in your worksheet then some formulas
may not be updated when the sheet is recalculated.

If you are not in automatic calculation mode (Tools / Options /
Calculation / Automatic) then the formula will not automatically update
when the data in A1 changes.


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup