=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!