| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I absolute cell an operator: and/or
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| have Excel retrieve conditional operator ( < = ) from a cell | Excel Worksheet Functions | |||
| Making cell reference absolute makes cell format text | Excel Worksheet Functions | |||
| How to use a cell value as operator in a worksheet reference? | Excel Worksheet Functions | |||
| The absolute referenced cell does not move when source cell moves | Excel Worksheet Functions | |||
| add one cell with no equals operator | Excel Discussion (Misc queries) | |||
Linear Mode
