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.


Please Login or Register  to view this content.
HTML Code: 
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.

Please Login or Register  to view this content.
Thanks in advance