Between function

M

Mike

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.
 
J

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
 
J

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
 
M

Mike

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