View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default "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.