request formula

  • Thread starter Thread starter Ann
  • Start date Start date
A

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
 
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
 
i want exactly 5, thanks!

Rick Rothstein (MVP - VB) said:
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
Click to expand...
 
Back
Top