Between function
 

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.

Between function
 

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

- John

Between function
 

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

- John

Between function
 

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

"John Michl" wrote:

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

- John