'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

'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

'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