IF problem

[magmike]

My desired result, is to have C4, copy the value from C3 if G4 contains
text. The problem is, the C column cannot contain the formula. I have tried
a formula in column H (unused otherwise), but it is not working. This is
what I did in H4.

=IF(G4="","",C4=C3)

Thanks in advance for your help.

 

[Andy B]

Hi

You cannot force values into cells with formulas. Excel cannot push data
without using VBA. If C4 cannot contain the formula, you'll have to use a
macro.