Google Sheets IF statement merged with concatenate

concatenation, google-sheets, google-sheets-formula, if-statement

Solution

Do this instead:

=IF(N3=100, concatenate("Text",A3), "Result")

Problem

I am trying to get the following statement to work. ``` =IF(N3=100, (=concatenate("Text",A3;)), "Result"). ``` Keep on coming with an error. Any ideas please?

Original source