=IF($BG$4="AND",--AND(DC9CU9,EE9CU9),IF($BG$4="OR",--OR(DC9CU9,EE9CU9),""))
--
David Biddulph

"nastech" wrote in message
...
Trying to be able to modify a column externally, to choose between AND/OR,
e.g.:


IF($BG$4&(DC9CU9,EE9CU9),0,1)
IF(INDIRECT($BG$4)&(DC9CU9,EE9CU9),0,1)
IF(INDIRECT($BG$4)(DC9CU9,EE9CU9),0,1)

where bg4 is to have either: AND, OR

have tried use of Indirect, not working.. any ideas, thanks