Column G contains percentages in decimal format. I need to to check the following conditions for thousands of lines:- The date in column L percentage value around .06 (column G) is only for dates before 12/31/08.
- The date in column L percentage value around .75 (column G) is only for dates after 1/1/09.
- Column J needs to contain the the words "OUT" or "STATE" if the percentage value (Column G) is around .15.
Hopefully this makes sense. I've tried so many combinations of formulas and I felt like this was the closest I've gotten to a result. I've posted the old code below that I've been using...but I don't like #N/A's and errors displaying...I'd much rather have a cleaner looking worksheet for the sake of others.
Thanks in advance
Bookmarks