Apr 16 2023 04:28 AM
I wish to change two cells in my value_if_true clause:
if(A1="Yes",(B1=1,C1=2),D1="Done")
Possible?
Thanks.
Apr 16 2023 05:44 AM
SolutionYou 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, "")