I need some help

I

Ilneval

What I need to be able to do is return a range of data based off of
calculation. Here is an example of what I nee

Widget 36.27
Gadget 31.27
Sprocket 43.35

Ok, I need to find all product that is 1.3 times higher percent, an
.77 times lower in percent than Widget at 36.27

Basically return all values that are between 36.27*1.3 and 36.27*.7
and equal to 36.2

Can anybody help me do this

Thanks
Ilneva
 
C

CLR

Take a look at the Data > Filter > AutoFilter feature.......click the arrow
at the top of the % column and set the filter for custom > Greater than AND
Less than.....

hth
Vaya con Dios,
Chuck, CABGx3
 
B

Bernard Liengme

With your data in A1:B(whatever)
In C2 enter =IF(AND(B2>$B$1*0.77,B2<$B$1*1.3),"X","")
Copy down the column
If B2's value is in range 36.77*.77 and 36.77*1.3 the C2 cell will have an X
Any use?
 
I

Ilneval

I see what you are saying, but I am not able to have it do th
calculation right?

The calculation is probably the single most important par tof m
problem, and believe me, I have been messing with this thing for 2 day
no
 
I

Ilneval

Bernard said:
With your data in A1:B(whatever)
In C2 enter =IF(AND(B2>$B$1*0.77,B2<$B$1*1.3),"X","")
Copy down the column
If B2's value is in range 36.77*.77 and 36.77*1.3 the C2 cell will have
an X
Any use?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


in
message news:[email protected]...
Click to expand...


Here is what I have for data Columns A-I contain data. Column F is
where the percentage number is. and there are 2187 lines of data.

Here is the formula I have entered into column J:
=IF(AND(F2096>$F$22*0.77,F2096<$F$22*1.3),"X","") Keeping in mind that
this is copied from cell J2096

I looked back through and it does not place an "X" in the column
 
B

Beege

I1neval,

Have you tried conditional formatting, changing perhaps to bold or a color
when these conditions are met?

Beege
 
Top