generating a formula using a text string as a math operator (expression)

[jey_sea]

Hi, need help with generating a formula. I'm grabbing a text string from a cell that may contain any one of the four following:
<,>, <=,>=.

Question; how can I generate a formula with the string as an math operator?

example:

Operator = cell(1,1) ' note cell contains "<="
If X Operator Y Then .....
note the expression (in red) should be If X <= Y Then ......

I'm sure someone out there has done this before>.

Thanks

 

[VoG]

This isn't very clear. I understand where the operator comes from. What goes to the left and right of it?

 

[jey_sea]

Hi, sorry for more being more clear!

If X is less then or equal to Y then
cell(2,1)="Pass"
else
cell(2,1)="Fail"
end if


the less then or equal to is the string from Cell(1,1) ; ie "<="

 

[VoG]

Maybe like this

If Evaluate(Cells(5, 1).Value & Cells(1, 1) & Cells(2, 1).Value) Then
    Cells(2, 1) = "Pass"
Else
    Cells(2, 1) = "Fail"
End If

 

[jey_sea]

Hi, sorry for more being more clear!

If X is less then or equal to Y then
cell(2,1)="Pass"
else
cell(2,1)="Fail"
end if


the less then or equal to is the string from Cell(1,1) ; ie "<="

 

[jey_sea]

Thank you very much; the function Evaluate works great!