"IF" formula returns zero or other incorrect number
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.
|