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.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!