request formula

[Ann]

I have a list of data points such as 1,2,4,14 and I need to have a column
that finds each time the data points move by an absolute value of 5.
tia

 

[Rick Rothstein \(MVP - VB\)]

Your question is not clear as to whether you want to mark differences that
are exactly 5 or 5 or greater. If exactly 5, use this formula...

=IF(ABS(A2-A1)=5,"X","")

If 5 or more, use this formula...

=IF(ABS(A2-A1)=>5,"X","")

Rick

 

[Ann]

i want exactly 5, thanks!

Your question is not clear as to whether you want to mark differences that
are exactly 5 or 5 or greater. If exactly 5, use this formula...

=IF(ABS(A2-A1)=5,"X","")

If 5 or more, use this formula...

=IF(ABS(A2-A1)=>5,"X","")

Rick