To "copy" B2 content without having a formula in B3 would require VBA code.

Formulas cannot copy to a blank cell.


Gord Dibben MS Excel MVP

On Thu, 24 May 2007 07:06:00 -0700, lespal
wrote:

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.