formula to copy contents of a cell to another based on condition.

[Chuckers]

Hello
Here is what I would like to do.
In cell C2 create a formula to do the following:
if cell A32 is <=0, copy cell B31 to B32.
if cell A32 is >0, do nothing.
Thank you very much.

[Pete_UK]

You can't have a formula in C2 which copies data into cell B32.

Perhaps you want a formula in B32 like this:

=IF(A32<=0,B31,"")

Hope this helps.

Pete

[Chuckers]

Thank you very much Pete. Your formula works but it isn't what I need. I'll try to figure another way around this.