extracting values >2 in excel?

Question

I have a list of values in excel. I would like to be able to search for values that are >2 and values <5. What would be the formula?

Answer 1

If your list is in column format, the easiest formula is:
=AND(A1>2,A1<5)

The above would be placed in column B1, then copied down that column untill you reach the last number in column A.

The results will be either the word TRUE or FALSE in blocks under column B.
______________________________________________
you can spice it up a but by using Conditional Formating:

You can specify that each TRUE return cell be fill with the color GREEN, and each FALSE cell be filled with the color RED. that way you can identify them rapidly.

Hope this helps. Cheers!

Answer 2

=if(a2>2,1,0) will test cell a2, and if greater than 2 will put a 1 in the results cell . If not >2, will put a zero..the 1 and zero can be whatever you want them to be. Leave out the zero and the formula will leave the answer blank. Use the formula help in Excel to help with these things.

Answer 3

NOTE:

A1 represents the field where the value is stored.

1. Create this formula in B1 column

= IF(A1>2,IF(A1< 5,"TRUE","FALSE"),"FALSE")

2. Drag this formula to the poinmt where values exist in Acolumn.

TRUE represents value >2 but < 5
and FALSE as understood

Answer 4

Hi,
go to Data Menu and select Auto Filters.
you will notice in the top of the column that a drop down list was created.
click the arrow of this drop down list and select custom
a dialog box will be opened
in the first bex select is greater than in the second box select 2.
select and
in the third box select is less than in the forth box select 5
click ok

You did it.

Regards

Answer 5

you can write the formula below in the cell next to your value and copy it for the whole column. then sort by the results

=IF((A1<5),IF(A1>2,A1,""))

The A1 is the cell that you are trying to test.

The "" will return a blank cell. You can also substitute a text message such as "NO" or "N/A" and still be able to sort your results.
hope this helps

Answer 6

not gonna do all that but you need a if then formula most likely nested and having an output sheet possibly with an array. excel is pretty user friendly on stuff like that, just look through the formulas and you should be able to figure it out

Answer 7

To flag each cell in column A use this in column B

=AND((A8>2),(A8<5))

Answer 8

try find as in find 3 and find 4.