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

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

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

Hi, you can try this. If your amount is in A2 ....

=IF(A2<75;A2+25;(IF(A2<150;A2+30;(IF(A2<250;A2+50; (IF(A1<350;A1+60;(IF(A2<500;A1+75;IF(A1<700;A1+90; (IF(A1<1000;A1+110;A1+200))))))))))))

IF the first statement is correct (under 75) it adds 25, if not it checks
the second (under 150) if it's correct it will add 30, if not it goes on
checking.
Not sure what should be happening for amounts like 75.50, so this might not
be exactly what you need.

"Morefeus Direct" wrote:

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

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

Oops, you probably don't have norwegian excel, so you'll need to swap ; to ,

"Light" wrote:

Hi, you can try this. If your amount is in A2 ....

=IF(A2<75;A2+25;(IF(A2<150;A2+30;(IF(A2<250;A2+50; (IF(A1<350;A1+60;(IF(A2<500;A1+75;IF(A1<700;A1+90; (IF(A1<1000;A1+110;A1+200))))))))))))

IF the first statement is correct (under 75) it adds 25, if not it checks
the second (under 150) if it's correct it will add 30, if not it goes on
checking.
Not sure what should be happening for amounts like 75.50, so this might not
be exactly what you need.

"Morefeus Direct" wrote:

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