Search code examples
if-statementgoogle-sheetsconcatenationgoogle-sheets-formula

Google Sheets IF statement merged with concatenate

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?

Solution

  • Do this instead:

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