Find in a range

[czar86]

Hi everybody im new here and I already have a question for you guys

So I gotta find mif a cell is between a range of numbers

Something like IF a1>=100 but <400 then 50, if a1<400 but <600 then 100, if a1 <600 but >800 then 150

Hope you guys understand I just need that Excel give me a number if "a1" its between 100 and 400 or 400 and 600

Thanx

 

[BenMiller]

Try

=IF(AND(A1>=100,A1<400),50,IF(AND(A1>=400,A1<600),100,IF(AND(A1>=600,A1<800),150,"NONE")))

 

[czar86]

Try

=IF(AND(A1>=100,A1<400),50,IF(AND(A1>=400,A1<600),100,IF(AND(A1>=600,A1<800),150,"NONE")))

Thanx for the response but sends me an error here 100,A1

 

[BenMiller]

Thanx for the response but sends me an error here 100,A1

You mean if A1=100 you get an error? I can't seem to reproduce that: this is a fairly simple IF statement, and it should return 50 when A1=100. If no matches are found it will return "NONE".

 

[czar86]

You mean if A1=100 you get an error? I can't seem to reproduce that: this is a fairly simple IF statement, and it should return 50 when A1=100. If no matches are found it will return "NONE".

Actually excel says my formula is wrong and I cant even use it, when the error shows the cursors highlight that part of the formula

 

[BenMiller]

Actually excel says my formula is wrong and I cant even use it, when the error shows the cursors highlight that part of the formula

Make sure to copy the entire formula:

=IF(AND(A1>=100,A1<400),50,IF(AND(A1>=400,A1<600),100,IF(AND(A1>=600,A1<800),150,"NONE")))

Select B1, hit F2 to enter edit mode, and hit CTRL+V.

 

[czar86]

Ok I was able to sort it out it was my mistake, but thanx for the help that solve my problem

 

[BenMiller]

Ok I was able to sort it out it was my mistake, but thanx for the help that solve my problem

No problem! Glad I could help