| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula request.... | Excel Discussion (Misc queries) | |||
| Formula request | Excel Worksheet Functions | |||
| Request a formula! | Excel Worksheet Functions | |||
| IF AND FORMULA REQUEST | Excel Discussion (Misc queries) | |||
| Formula help request | Excel Discussion (Misc queries) | |||
Hybrid Mode
