Forum Discussion

Copper Contributor

Apr 16, 2023

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.

Formulas and Functions

HansVogelaar
Apr 16, 2023
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, "")

MVP

Apr 16, 2023

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

Resources