software

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.

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

- JohnYou can use the AND function. Try =AND(B2gt;100,B2lt;400) in cell C2 of
your example. Then copy it down.

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

quot;John Michlquot; wrote:

gt; You can use the AND function. Try =AND(B2gt;100,B2lt;400) in cell C2 of
gt; your example. Then copy it down.
gt;
gt; - John
gt;
gt;