Thread: Formula which returns result in two seperate cells

hi, I need a formula which returns a result in two seperate cells.


The concept is this -
If A1 has a "2" then A2 AND A3 should be populated with a "2", if A1 doesn't have a 2 then A2 and A3 should be blank. The formula MUST be in cell A2 (for complex reasons I can't go in to).

The closest I could come up with is this -
=IF(A1=2,A2=2 & A3=2,"")

I can make the formula work for just A2 with this -
=IF(A1=2,2,"")

but this doesn't take care of cell A3.

Any help would be appreciated.
Thanks

You'll need two formulas - one in cell A2 and one in cell A3. You can change the state of a cell with a formula in a different cell. You can with VBA, if you need another option.