IF forumla to check if a value falls between two numbers

  • new to excel, and i have been asked to find an if statement that would check column F's Value to see if it is between 531108 and 531140 if so value in column L equals 20/07/16; if not then check to see if the value is between 531141 and 531241 if so value in column l equals 20/06/16; all other values in column F give you 15/07/16 in column L.
    Thanks in advance.

  • Re: IF forumla to check if a value falls between two numbers


    tRY:


    [COLOR="#0000FF"]=IF(AND(F2>=531108,F2<=531140),DATE(2016,7,20),IF(F2<=531241,DATE(2016,6,20),DATE(2016,7,15)))[/COLOR]


    Where F2 contains number you are checking. The formula can be copied down to check F3, F4, etc.

    Where there is a will there are many ways. Finding one that works for you is the challenge!


    MS Excel MVP 2010-2016