Trying to pull greater than, less than, equals to from text.

[sin2190]

Good morning fellow excel users,

Quick question, is it possible to pull the "<" symbol from a cell for a formula.

For example lets say I have this formula.
A1=1
In cell A2 =IF(A1=1,">","<")
A3=2
A4= =IF(A1&A2&A3,"greater than","less than") <---- Trying to fix this to read if A1>A3, greater than else less than.

Of course it more complex than this but I am trying to use an if statement to determine if I need greater than or less than symbol than to use that information to compare it elsewhere.

 

[Georgiboy]

Maybe:

Range("A4").Formula = "=If(" & Range("A1").Address & Range("A2").Value & Range("A3").Address & ",""Greater than"",""Less than"")"