creating IF formulas in excel

K

Kowalskii

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

aristotle

Hi,

Something like:

=IF(AND(B1>=0,B1<=50),B1+50,IF(AND(B1>50,B1<=100),B1+70,IF(AND(B1>100,B1<=150),B1+90,IF(AND(B1>150,B1<=250),B1+120,"No condition met"))))

Regards,
A
 
Top