Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine an OR condition with an AND condition
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... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine an OR condition with an AND condition
=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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use condition | Excel Discussion (Misc queries) | |||
If condition | Excel Discussion (Misc queries) | |||
Max or Min with condition | Excel Worksheet Functions | |||
Condition 1 overules condition 2? | Excel Worksheet Functions | |||
Condition sum | Excel Worksheet Functions |