Answer the question
In order to leave comments, you need to log in
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
=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 questionAsk a Question
731 491 924 answers to any question