creating IF formulas in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,90,if(A1<=250,0)))))
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Grid Lookup 1
Hiding Formulas 2
Function 2
summing data in multiple columns 4
Average problem 1
Mutiple IF(AND) too many conditions 7
hide multiple worksheets based on a formula value in one cell 1
averaging data in multiple columns 6

Back
Top