Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"AND" & "OR" in a IF loop
how do I combine AND and OR in a nested IF statement.
eg: IF((AND(ab=5,ac=1)or(ac=2),"correct",if(........)) ) pls help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"AND" & "OR" in a IF loop
Maybe like this:
=IF(AND(AB1=5,OR(AC1={1,2})),"correct",IF(........ ........... Biff ""AND" & "OR" in a IF loop" <"AND" & "OR" in a IF wrote in message ... how do I combine AND and OR in a nested IF statement. eg: IF((AND(ab=5,ac=1)or(ac=2),"correct",if(........)) ) pls help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop time seems dependent on unrelated workbook - Why? | Excel Worksheet Functions | |||
Combining "AND" with "OR" Statements | Excel Worksheet Functions | |||
Loop gone crazy | Excel Discussion (Misc queries) | |||
Do Loop | Excel Discussion (Misc queries) | |||
hysteresis loop | Charts and Charting in Excel |