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
Where F2 contains number you are checking. The formula can be copied down to check F3, F4, etc.