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

7
90 TRUE
91 FALSE
92 FALSE

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)

"carl" wrote in message
...
I am looking for a formula for ColB below that will produce this result:

7
90 TRUE
91 FALSE
92 FALSE

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.

How about:
=NOT(((A2-A1)=1)) and copy down
--
Gary's Student


"carl" wrote:

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

7
90 TRUE
91 FALSE
92 FALSE

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.