"IF" formula returns zero or other incorrect number
 

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.

"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.

"IF" formula returns zero or other incorrect number
 

The formula is: =IF(D23=D22,D23,D22). D23 value = 0. D22 = 24,000. Expected
result 24,000. Result 2,700.

"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.

"IF" formula returns zero or other incorrect number
 

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
editpaste special and select add


--

Regards,

Peo Sjoblom


"Pat K." wrote in message
...
The formula is: =IF(D23=D22,D23,D22). D23 value = 0. D22 = 24,000.
Expected
result 24,000. Result 2,700.

"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.

"IF" formula returns zero or other incorrect number
 

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.

"IF" formula returns zero or other incorrect number
 

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.

"IF" formula returns zero or other incorrect number
 

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.

"Niek Otten" wrote:

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.