"IF" formula returns zero or other incorrect number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Please give your formula, the values of the input cells, the expected result
and what you got instead
 
The formula is: =IF(D23>=D22,D23,D22). D23 value = 0. D22 = 24,000. Expected
result 24,000. Result 2,700.
 
If the value in D23 is text it will be seen as greater than a number
Try

=ISTEXT(D23)

if that returns TRUE it is text, copy an empty cell, select D23 and do
edit>paste special and select add
 
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.
 
I think the solution is in Peo's answer.
test all the cells carefully with his suggested approach
 
I tested as suggested and the answer came up FALSE. After working the spread
sheet through my mind during one of those early morning "twilight zone"
periods, I decided that the problem was a complicated circular formulation
involving a long string, so I broke the string by reformulating the
calculation of D24 to avoid D23. That seemed to work. Thanks for your help.
 
Back
Top