If And Between Ranges

  • I'm trying to get a formula to give and yes or no answer if a cell is between two numbers.

    Example: Cell AB9 = 100.2 in cell AB11 would be a formula that would answer "Yes" because it is between 96.8 and 100.4. Any number outside this range would answer "No."

    An help would be great.

  • Re: If And Between Ranges

    Quote from Brister

    Or you can use this which will give you Yes or No


    Good call, Brister.

    I slipped on the Yes or No.:drunk:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!