Can't find my post

[Frank]

Hi, I posted a question yesterday and checked 10 minutes later to see if it
was posted and it was. Now tonight, I can't find it at all! I have searched
every possible way I know. Any suggestions anyone?
Frank

 

[Trevor Shuttleworth]

Range between cells

It is there; response from 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)

--
Regards
Frank Kabel
Frankfurt, Germany

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

 

[Debra Dalgleish]

The Google newsgroup archive is a good place to look for posts:

http://groups.google.com/advanced_group_search?as_ugroup=*excel*

Enter your name as the author, and some keywords from the missing post.

 

[Frank]

Thanks Trevor & Debra! I appreciate your time in helping me Also thank
you Frank Kabel for answering!