Im sure there will be a simple answer to this one, but Im struggling to find
it!!
I have data in one column and I wish fill the next cell with the results of
a sum on the data.
the formula should work something like this:
if source data is between 0-50, add 50
if source data is between 50-100, add 70
if source data is between 100-150, add 90
if source data is between 150-250, add 120.

I would be most grateful for any help!

=if(A1<0,0,if(A1<=50,50,if(A1<=100,70,if(A1<=150,9 0,if(A1<=250,0)))))

--
Regards,
Tom Ogilvy

"Kowalskii" wrote in message
...
Im sure there will be a simple answer to this one, but Im struggling to
find
it!!
I have data in one column and I wish fill the next cell with the results
of
a sum on the data.
the formula should work something like this:
if source data is between 0-50, add 50
if source data is between 50-100, add 70
if source data is between 100-150, add 90
if source data is between 150-250, add 120.

I would be most grateful for any help!

Hi,

Something like:

=IF(AND(B1=0,B1<=50),B1+50,IF(AND(B150,B1<=100), B1+70,IF(AND(B1100,B1<=150),B1+90,IF(AND(B1150,B 1<=250),B1+120,"No condition met"))))

Regards,
A

"Kowalskii" wrote:

Im sure there will be a simple answer to this one, but Im struggling to find
it!!
I have data in one column and I wish fill the next cell with the results of
a sum on the data.
the formula should work something like this:
if source data is between 0-50, add 50
if source data is between 50-100, add 70
if source data is between 100-150, add 90
if source data is between 150-250, add 120.

I would be most grateful for any help!