Forum Discussion
Solved
can I run multiple assignments from an if clause?
I wish to change two cells in my value_if_true clause:
if(A1="Yes",(B1=1,C1=2),D1="Done")
Possible?
Thanks.
You have to create a separate formula in each target cell.
For example in B1: =IF(A1="Yes", 1, "")
And in C1: =IF(A1="Yes", 2, "")
You have to create a separate formula in each target cell.
For example in B1: =IF(A1="Yes", 1, "")
And in C1: =IF(A1="Yes", 2, "")
