Hello,

I have an inventory of over 6000 items. In order to do a systematic cycle count, I would like to breakdown the inventory in multiple groups based on the unit cost of the item, such as:

Selection Criteria Unit Cost
1 = $5,000
2 = $3000 <$5000
3 = $2000 <$3000
4 = $1300 <$2000
5 = $1000 <$1300
6 = $800 <$1000
7 = $600 <$800
8 = $400 <$600
9 = $200 <$400
10 = $100 <$200


In order to be able to select the items based on any desired criteria (either thru pivot table or filter button), I was thinking of adding a column named "Selection Criteria" and having in that column a formula that would derive the correct narration such as "=$5,000", "=$3000 <$5000", so on and so forth.

I would appreciate if someone can someone help in writing the expression. As a test, I wrote the expression as follows, which did not work. A2 has a value of 3557 and i was expecting to see a Y.

=IF(A2=3000<4000,"Y","N")

If someone can suggets a better method, i would appreciate.

Regards
SJ