Capture.PNG
I need some serious Excel help on this one.
In column D I have over 7000 decimal dates ranging from the mythical year 0 to 1999.
In Column Q I have a sample value of sulfate (SO4).
In Column V I have a list of years that are acting as my year range.
In Column AB I have a threshold that samples in Column Q must be above. This value represents an average between two dates from Column V. 1.485 is the average I found between years 1974 and 1999.
If the sample is above the threshold, I would like to have TRUE appear in Column S.
I need my IF statment to look at the value in Column Q, decide if the associated date in Column D is between 2 years in Column V. If it is, then look at the value from Column Q and see if it is above the associated value in Column AB. If it is, then say TRUE in Column S, if not, then leave blank or return FALSE.
For example, Q5 has value 0.59497 and is dated as 1998.96. Is this value greater than the 1.485 average from 1974 - 1999? No, then Column S should express this.
Help!
Bookmarks