If Question

[Guest]

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.

 

[Bob Phillips]

=abs(A1-a2)=1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

How about:
=NOT(((A2-A1)=1)) and copy down