condition solve with "text"

[carenel]

Hello community,

I am trying to compare two columns with numbers, if it is true then show me "soy" 

I am doing with IF. it is working with numbers but not with text.

How can it run?

IF ( Tabla[risk_l] = Tabla[vspy],"soy",0 )

Many thanks

[rsbin · Accepted solution]

@carenel,

Your new column cannot have multiple formats.  In other words you cannot mix text with numbers.

That is why it works when both are numbers.

Suggest you change 0 to "" or some other text string that makes sense for your situation.

Regards,

[carenel]

many thanks...... it was so easy. 😀