Can I absolute cell an operator: and/or
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
|