=IF(OR(A1="ON",AND(A1="OFF",A1=[last record of day])),[then],[else])

You need to replace the stuff in the square brackets [ ] with your
appropriate logic, and change the cell reference to suit.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Will" wrote:

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...