adding in exel

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

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