| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
'OR' in Formula & # of Parameters
How do you enter 'or' in a formula? i.e. IF(a1=c1 or d1 ....
Is it possible to have more than 6 parameters in a formula for IF statements? Thank you. Mary |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
'OR' in Formula & # of Parameters
if(or(a1=c1,d1=3),"A","B")
You can nest IF statements to 7 levels if that is what you are asking. If you mean how many arguments can an OR function take, 1 to 30. -- Regards, Tom Ogilvy "Mary Z" wrote: How do you enter 'or' in a formula? i.e. IF(a1=c1 or d1 .... Is it possible to have more than 6 parameters in a formula for IF statements? Thank you. Mary |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
'OR' in Formula & # of Parameters
This is how you would apply the OR function to that.
=IF(OR(A1=C1,A1=D1),"At least one is true","Both are false") "Mary Z" wrote in message ... How do you enter 'or' in a formula? i.e. IF(a1=c1 or d1 .... Is it possible to have more than 6 parameters in a formula for IF statements? Thank you. Mary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Logic If formula - multi-parameters can not get to work?? | Excel Worksheet Functions | |||
| SUBSTITUTE formula -- variable spacing between parameters?? | Excel Worksheet Functions | |||
| Parameters for an excel formula | Excel Discussion (Misc queries) | |||
| formula to check balances within parameters | Excel Worksheet Functions | |||
| extracting parameters from formula | Excel Programming | |||
Hybrid Mode
