PDA

View Full Version : yes/no formula - 2 off and 1 on



hkossila
2011-09-30, 05:33 PM
I need a formula that if 2 yes/no parameters are off, and another one is on, it will turn a 4 parameter on:
Clamp 1 = off
Clamp 2 = off
Adjustable Clamps = on

then D= on

I can get it so D turns on if A and B OR if C, with the formulas below, but not all of them. Anyone know how I can do this?

D=not(and(or(Clamp 1, Clamp 2)))
or
D=Adjustable Clamps

Alfredo Medina
2011-09-30, 07:02 PM
I find at least 2 solutions. See illustration.