If number is between formula?

[themightyreds]

In column A I have weights ranging from 1 - 1500.

In Column B I what to return the whether the weight is -100, +100, +300, +500 or +1000.

is it possible to write an If formula using between?

All help appreciated!!

Matt

 

[schielrn]

Yes, you would so something like:

=if(and(x > y, x < z),"x is between y and z","x is not between y and z")

Hope that helps.

 

[themightyreds]

erm he says scratching his head? no I'm still struggling.


=if(and(x > y, x < z),"x is between y and z","x is not between y and z")

I can't seem to make that fit?

 

[schielrn]

I'm not really sure what you are asking in your original question or what makes the results return? Can you provide any sample data and expected results?

 

[lenze]

Try this

=IF(A1<100,"Less than 100",IF(A1<300,"Between 100 & 300",IF(A1<500,"Between 300 & 500",IF(A1<1000,"Between 500 & 1000","Greater than 1000"))))

lenze

 

[themightyreds]

Thanks Lenze works exactly as I need it to. I was thinking that I needed to find a formula which uses between you have shown me that by not meeting the conditions of the first IF it automatically creates the between situation for me! Genius!

 

[lenze]

I'm glad you caught on. I've found that one of the hardest concepts of IF to get across. I have, in fact, run into college profs teaching Excel who do not grasp it!!
lenze