Can I absolute cell an operator: and/or

N

nastech

Trying to be able to modify a column externally, to choose between AND/OR,
e.g.:


IF($BG$4&(DC9>CU9,EE9>CU9),0,1)
IF(INDIRECT($BG$4)&(DC9>CU9,EE9>CU9),0,1)
IF(INDIRECT($BG$4)(DC9>CU9,EE9>CU9),0,1)

where bg4 is to have either: AND, OR

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

David Biddulph

=IF($BG$4="AND",--AND(DC9>CU9,EE9>CU9),IF($BG$4="OR",--OR(DC9>CU9,EE9>CU9),""))
 
Top