I need to incorporate both an "AND" and an "OR" condition within and IF
statement... is that possible.

I need to say... IF the cell above is "ON" or IF the Cell above is "OFF" and
the record is the last of the day, then....

I hope you can understand that...