yes/no and conditional

[krista.manna]

Is there a way to do the following with yes/no parameters?

IF param 1 = yes & param 2 = yes, then param 3 = yes, if not param 3 = no

[Scott Womack]

Is there a way to do the following with yes/no parameters?

IF param 1 = yes & param 2 = yes, then param 3 = yes, if not param 3 = no

Parameter 3 = and(Param 1,Parrm 2)

If both 1 and 2 are True 3 is true.

[twiceroadsfool]

Nice, Scott! I typically have done those with an unnecessarily long If statement. I like your way MUCH better, LOL...

[spramanik]

Hi Scott,

I have 3 parameters A, B & C.
I need C=true when both A and B true.

The problem is when I applied the formula as-
C=and(A, B) it works also when either A or B is true. I need C true only when both A & B are true.

Thanx
spramanik