range between cells

[Guest]

Hi, I want to find out if the previous cell is within a certain % range of
the current cell. See below please:

A B
1 88
2 78
3 83
4 92 TRUE
Cell B4 contains the formula: =AND(A1>A2, A2<A3, A3<A4) Now I need to add
to this formula and still receive a "TRUE" by telling me for instance if cell
A1 is within say 15% of cell A2. Also if cell A2 is within 15% of cell A3.
Plus, if cell A3 is within 15% of cell A4.
Are there possibly 2 methods?
Method 1 : The previous paragraph would allow me to have different %
specified between each pair of cells.
Method 2 : Is it possible to type in the "15%" only once somewhere in the
formula and it would know to check between all specified cells in order to
result in a "TRUE" or "FALSE"?
I use Excel 97. Thank you very much to anyone who can help!
Frank

 

[Frank Kabel]

Hi
try the following:
1. Question:
- your data is in A1:A10
- in B2:B10 enter your percentages
- enter the following formula
=IF(SUMPRODUCT(--(ABS(A2:A10-A1:A9)/A2:A10>B2:B10)),FALSE,TRUE)



2. Question:
- your data is in A1:A10
- enter 0.15 in cell B1
- enter the following formula
=IF(SUMPRODUCT(--(ABS(A2:A10-A1:A9)/A2:A10>B1)),FALSE,TRUE)