How to Parameterize a symbol?

[Pobek]

Hi,

Let's say I have 10 in cell A1 and 11 in B1. If I put in the formulae "=A1<B1" into cell C1, I'll get a TRUE! I want to be able to make the symbol "<" a parameter such that I can put say (in C1):

"=A1indirect(D1)B1" with the "<" inputted in D1 to still be able to maintain the formulae integrity ... Does anyone have a clever formulae to make this possible?

 

[Pobek]

Sorry I must have cut out some of that information... here is what I initially typed:

Hi,

Let's say I have 10 in cell A1 and 11 in B1. If I put in the formulae "=A1<B1" ijn C1, I get a TRUE. I'd like to make the symbol "<" a parameter such that I can put in
"=A1indirect(D1)B1" (with the "<" inputted in D1) to still be able to maintain the formulae integrity ... Does anyone have a clever formulae to make this possible?

 

[steve the fish]

You would have to use VBA as far as im aware.

 

[Pobek]

You would have to use VBA as far as im aware.

I suspected so lol ... No worries.

 

[steve the fish]

You can fudge it by building the string and then copying pasting and reentering the formula.

 

[Pobek]

You mean VBA repopulating the front-end formulae? Yeah that's what I had in mind.

 

[RoryA]

You could also create a simple UDF in VBA to evaluate your formula.

 

[steve the fish]

Heres a function that works. Rory will be able to say if i missed anything:

Function eval(first As Range, oper As Range, last As Range)

eval = Evaluate("=" & first & oper & last)

End Function

 

[Pobek]

Thanks, I will try that.

 

[mikerickson]

Another work-around would use Names
Put 12 in A1, "<" in B1 and 36 in C1..


Select D1 and define a name,
Name: myEquation
RefersTo: =EVALUATE(Sheet1!A1 & Sheet1!B1 & Sheet1!C1)

Then put =myEquation in D1.

Because of the use of relative refenecing in the definition, dragging D1 downward will adjust to the row number