Between function

[Guest]

Does anyone have a simple way to determine if a value is between two others?
Example

Act# Balance
1 100
2 200
3 300
4 400

Want to know which ones are more than 100 but less than 400.

 

[John Michl]

You can use the AND function. Try =AND(B2>100,B2<400) in cell C2 of
your example. Then copy it down.

- John

 

[John Michl]

You can use the AND function. Try =AND(B2>100,B2<400) in cell C2 of
your example. Then copy it down.

- John

 

[Guest]

thank you. that works much better then the nested if statments i used. It
will be a huge help.
Mike