moving results to new column

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'

In B1

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

"grumpybbear" wrote:

>
> 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'
>
>
> --
> grumpybbear
> ------------------------------------------------------------------------
> grumpybbear's Profile: http://www.excelforum.com/member.php...o&userid=37446
> View this thread: http://www.excelforum.com/showthread...hreadid=571121
>
>