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