Hello,

Is it possible to have part of a formula in one cell that if the condition is true that it can take the value from a second cell and copy that into a third cell.



Say, Cell B2 has the formula, and if the condition is true it takes the value from Cell B1 and copies that into Cell D2.


=IF(B2>A2,D2=B1,"") IF B2>A2 then D2=B1 Else do nothing.

Thanks for your assistance.