Combine an OR condition with an AND condition

W

Will

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

Dave F

=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
 
Top