W
W
WebAnalytics12017-11-08 16:34:46
Google Sheets
WebAnalytics1, 2017-11-08 16:34:46

Google Sheets: How to make sure that if the value = X in the adjacent cell, then the CONCAT formula is executed?

Hello. Please help me write a formula/script that if it sees a certain value in a cell executes the formula, if not, it leaves it empty
Example:
=IF(E2 = "No";=CONCAT(A12;B2;B12))

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
kornilov-s, 2017-11-08
@WebAnalytics1

=IF(E2 = "No";CONCAT(A12;B2;B12);"")
No need to write "=" twice.
To make it empty, just specify empty quotes separated by a semicolon.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question