CODEWITHSUNDEEP
if-statementgoogle-sheetsconcatenationgoogle-sheets-formula
Dom
Dom

Reputation: 3126

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?

Upvotes: 2

Views: 8469

Answers (2)

player0
player0

Reputation: 1

you can simply do it like:

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

Upvotes: 0

RonaldBarzell
RonaldBarzell

Reputation: 3830

Do this instead:

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

Upvotes: 6

Related Questions