adding in exel

[Guest]

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

 

[CLR]

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

 

[Guest]

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

 

[Guest]

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.

 

[Don Guillett]

If c1 is your number then the c2 formula could be
=VLOOKUP(C1,C29,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.

 

[Guest]

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