Thanks Bob,
My question was not clear. I need to copy the value contained in cell B2
into B3 if the value in B1 is true.

Les Palmer

"Bob Flanagan" wrote:

In B3 put the following formula:

=If(B1, B2, "")

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"lespal" wrote in message
...
I want to copy a value cell B2 into cell B3 IF a value in B1 is true.