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.
    Thanks,
    Wattage

  • Re: If And Between Ranges


    Quote from Brister

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


    Code
    =IF(AND(A1>96.8,A1<100.4),"Yes","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!