View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] davidbarbetta@yahoo.com is offline
external usenet poster
 
Posts: 1
Default have Excel retrieve conditional operator ( < = ) from a cell

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!