Using Logical Operators present in a cell in an IF statement

[Bill_49001]

Hello! I've been a big fan of this site for a couple years but have never posted. I'm hoping that you can help with my problem.

I need to compare two number values using a logical operator that is also a cell in the table.

How can I refer to a cell for the logical operator in an IF statement? See attached file for an example of my data. I'm trying to calculate column D with a formula.

IF(A2??C2,"TRUE","FALSE")
where ?? is the operator present in cell B2

 

[shrivallabha]

Goto Name Manager and Define a name:
eval
In refers to put following formula:
=EVALUATE(Sheet1!$A2&Sheet1!$B2&Sheet1!$C2)
and then in cell D2 simply put:
=eval
It will get copied down automatically.

Since Evaluate is XLM macro function it will prompt you to save it as macro enabled workbook.

 

[NARAYANK991]

Hi ,

See if this works !

In D2 , enter the following formula , and copy down :

=(SUMIF(Table1[@[Actual Value]],Table1[@[Limit Comparison]] & Table1[@Limit]) <> 0)

Narayan

 

[shrivallabha]

Hi ,

See if this works !

In D2 , enter the following formula , and copy down :

=(SUMIF(Table1[@[Actual Value]],Table1[@[Limit Comparison]] & Table1[@Limit]) <> 0)

Narayan

Much better and easier to implement . One more similar idea.
=COUNTIF([@[Actual Value]],[@[Limit Comparison]]&[@Limit])=1