Not too srue what you are driving at here. You can use the logical And / Or
functions

=if(and(A1 = 1, B1 = 1), true, False)
Which can be simplified to
=and(A1 = 1, B1 = 1)

there is also an or function
=or(a1 = 1, B1 = 1)

finally you could use nested if functions
this mimics the above or function
=if(A1 = 1, true, if(b1 = 1, true, false)
And this mimics the and function
=if(A1 = 1, if(B1 = ,true, false), false)
--
HTH...

Jim Thomlinson


"Jessica" wrote:

Is there any way of having more than one scenario in an arguement so that the
"TRUE" answer will depend on more than one "IF"