moving results to new column

grumpybbear · Aug 13, 2006

i have a result of a formula in cell 'A1'. what i need now is to be able
to move that result to say 'B1' if 'A2'='1'

Toppers · Aug 13, 2006

In B1

=IF(A2=1,A1,"") will set B1=A1 if A2=1 else B1 will be empty ("")