I think the solution is in Peo's answer.
test all the cells carefully with his suggested approach

--
Kind regards,

Niek Otten

"Pat K." wrote in message
...
Niek: Hi.Interestingly, when I went back to the workbook fter responding
to
you, the cell containing 2,700 had changed to "0". I should add that the
input cells all have formulae in them that refer to cells on another page.
the displayed numbers in these cells are all the expected numbers.

"Niek Otten" wrote:

Please give your formula, the values of the input cells, the expected
result
and what you got instead

--
Kind regards,

Niek Otten

"Pat K." <Pat wrote in message
...
I have a workbook consisting of three interactive pages that I have
worked
with for twoyears. Recently various cells have begun to return
inncorrect
numbers, most often "Zero". Auditing the formula results in the formula
screen (use of Fx function) displaying the correct number, even while
the
cell is displayingan incorrect number.