ExcelBanter - request formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - request formula (https://www.excelbanter.com/excel-worksheet-functions/192471-request-formula.html)

ann

request formula

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\)[_748_]

request formula

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" wrote in message
...
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

ann

request formula

i want exactly 5, thanks!

"Rick Rothstein (MVP - VB)" wrote:

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" wrote in message
...
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

All times are GMT +1. The time now is 05:39 PM.