Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'd like to enter "<" "" "=" "<=" "=" in a cell (e.g. cell E11), and
then have a formula which evaluates based on that entry. (I'm analyzing a ton of data and I need one formula I can paste throughout the worksheet.) The formula I'm working with is: =SUMPRODUCT(--(INDIRECT(E$9)<E$12),--(Machine=$B21)) Is there any way to substitute the entry in cell E11 ("<" "" "=" etc) for the "<" in my formula? Something like =SUMPRODUCT(--(INDIRECT(E$9) LOGICOPERATOR(E$11) E$12),--(Machine= $B21)) where LOGICOPERATOR(E$11) would be interpreted as "<" "=" "=" or whatever was in cell E11? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to use a cell value as operator in a worksheet reference? | Excel Worksheet Functions | |||
MAJOR BUG: Excel operator precedence is wrong | Excel Worksheet Functions | |||
Help - retrieve cell address | Excel Discussion (Misc queries) | |||
add one cell with no equals operator | Excel Discussion (Misc queries) | |||
Retrieve last cell with data | Excel Worksheet Functions |