adding in exel

[Morefeus Direct]

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



"Morefeus Direct" <[email protected]> wrote in
message news:[email protected]...
> 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

[Morefeus Direct]

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" <[email protected]> wrote in
> message news:[email protected]...
> > 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
>
>
>

[Light]

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

[Don Guillett]

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
[email protected]
"Morefeus Direct" <[email protected]> wrote in
message news:[email protected]...
> 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" <[email protected]> wrote in
>> message news:[email protected]...
>> > 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
>>
>>
>>

[Light]

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