software

I am looking for a formula for ColB below that will produce this result:

7
90TRUE
91FALSE
92FALSE

Would like the formula to look at the difference between A1 and A2, A2 and
A3 etc. If the difference is equal to 1, return false.

Thank you in advance.=abs(A1-a2)=1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;carlquot; gt; wrote in message
...
gt; I am looking for a formula for ColB below that will produce this result:
gt;
gt; 7
gt; 90 TRUE
gt; 91 FALSE
gt; 92 FALSE
gt;
gt; Would like the formula to look at the difference between A1 and A2, A2 and
gt; A3 etc. If the difference is equal to 1, return false.
gt;
gt; Thank you in advance.
gt;
How about:
=NOT(((A2-A1)=1)) and copy down
--
Gary's Studentquot;carlquot; wrote:

gt; I am looking for a formula for ColB below that will produce this result:
gt;
gt; 7
gt; 90TRUE
gt; 91FALSE
gt; 92FALSE
gt;
gt; Would like the formula to look at the difference between A1 and A2, A2 and
gt; A3 etc. If the difference is equal to 1, return false.
gt;
gt; Thank you in advance.
gt;