|I am trying to save work on 4000+ rows of data using the IF(AND function. Having trouble getting it to work. (I am using Google Docs Spreadsheet, btw). Using dates seems to complicate things.|
If the date is between two values (which will be adjacent to the next date), I want to display a number based on that range, so:
If date is between 1/3/1941 and 1/2/1943, display "77"
If date is between 1/3/1943 and 1/2/1945, display "78" and so on...
I can't get this to work using nesting IF(AND, and can't even get IF(AND to work with only one range.
For instance, if the value in I2 = 11/4/1941, in I3 I have =IF(AND(I2>=1/3/1941,I2<=1/2/1943),"77","ERROR") . "ERROR" shows up, when "77" should be returned. When I try multiple IF(AND's I get an error in the cell. If I change the value in I2, I never get "77" to show up in I3.
I'm using <= and >= and am okay with using just < and > and adjusting days if that may be the issue.
Thanks for any help