If c1 is your number then the c2 formula could be
=VLOOKUP(C1,C2:D9,2)
76 30
0 25
76 30
151 50
251 60
351 75
501 90
701 110
1001 200

If you want to Replace all numbers in the column with the new values you can
either change the result to values or use a looping macro, problably with a
select case, to change all values with one mouse click.

--
Don Guillett
SalesAid Software

"Morefeus Direct" wrote in
message ...
thanks for the reply, the and so on is, $251 to $350 add $60 - $351 to
$500
add $75
$501 - $700 add $90 - $701 to $1000 add $110 - and $1001 and up add
$
200, and i'm not familiare with IF or VLOOKUP please exsplane .

thanks again

Morefeusdirect.com

"CLR" wrote:

There's no way to do what you ask, staying within the one column by using
formulas.....as a cell can contain either a value, or a formula......it
might be done using code, but more details would be needed for the "and
so
on" part......a better solution would probably be by using a helper
column
with an appropriate IF or VLOOKUP type formula.......still the range
beyond
$250 would have to be defined.

Vaya con Dios,
Chuck, CABGx3



"Morefeus Direct" wrote in
message ...
hi, i have a problem, i'm trying to add to numbers in a column, i have
a
column with 1000 different prices, is there a way to add to the
different
groups within this column? "example" prices from $0 to $75.00 add
$25.00
- $76.00 to $150.00 add $30.00 - $151.00 to $250.00 add
$50.00
and so on, all within this one column and all in the different groups?

thanks

Morefeusdirect.com