Incorrect results

[dave parks]

I am using the "IF" formula and it is returning the incorrect results for
some of the cells on my worksheet. For example, =IF(Q14>R14,1,0). Q14 is >
R14 but it is returning 0 as a result instead of 1. It only does it when one
of the values is less than ten. If both values are double-digits, then it
yields the correct results.

 

[Peo Sjoblom]

Sounds as though the values are text, text is always greater than numbers
and 9 text is for instance greater than 50 text

if any of these 2 formulas are TRUE that's the case

=ISTEXT(Q14)
=ISTEXT(R14)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[dave parks]

I went to the cells in question and formatted the numbers. The values are now
set as "number". I saved it and reloaded the worksheet and it is still not
working properly.

 

[Myrna Larson]

Changing formatting does not change the data type of the cell contents. If you
widen the column, and set the alignment to general, if the numbers are truly
numbers, they will be right-aligned. If they are text, left-aligned.

To convert text that looks like a number, to a number, Edit/Copy a blank cell.
Then select the column with the text "numbers" and Edit/Paste Special and
select the Values and Add options.

On Tue, 28 Sep 2004 05:41:04 -0700, "dave parks" <dave