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!