SOLVED

can I run multiple assignments from an if clause?

Copper Contributor

I wish to change two cells in my value_if_true clause:

if(A1="Yes",(B1=1,C1=2),D1="Done")

Possible?

Thanks.

 

1 Reply
best response confirmed by Needsleep (Copper Contributor)
Solution

@Needsleep 

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, "")

1 best response

Accepted Solutions
best response confirmed by Needsleep (Copper Contributor)
Solution

@Needsleep 

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, "")

View solution in original post