Not quite sure what you want but you could use a VLOOKUP table, a choose
function or simply IF.
=if(a110,1,if(a15,2,if(a11,3,4)))


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Guilherme Loretti" wrote in
message ...
Hi there,

I was wondering if you guys can come up with a easier and quicker solution
to work with ranges in Excel.
For example:

I need to classify prices ranges.
PRICE
$2.50
$1.72
$12.00
$4.50

RANGES
<$1.00
$1.00 AND <$5.00
$5.00 AND <$10.00
$10.00

I can do this, using IFs but if you dramatically changes the ranges and
include many, it's very time consuming.

How can I do this on a more automated fashion?

Btw, Excel could provide some wizard tool to create those ranges as it has
for subtotals, pivot tables, etc.

Thanks