IFERROR equivalent (if then else)

[MartinL]

I have check two columns of data to get a reliable result as a result of building the two columns either, both nor neither columns will contain Error - in my case its always Expression.Error: The 'offset' argument is out of range. due to a Text.Range type formula, which is fine

What I next need to do is something along the lines of if column A [HasError] then column B else column A
if after this there are still errors then I can use the Remove Errors function.

But how do I write the if...then...else statement

 

[MartinL]

I have check two columns of data to get a reliable result as a result of building the two columns either, both nor neither columns will contain Error -

Ok A workaround was to avoid the Error in the first place
What I have done is use:

try Text.Range([Column A],Text.PositionOf([Column A], "T"), 5)&"40" otherwise "X"

try Text.Range([Column B],Text.PositionOf([Column B], "T"), 5)&"40" otherwise "X"

[if Text.Start([Columm A],1)="X" then [ColumnB] else [Column A]

And then filter where Column C does not equal "X"