IF problem

  • Thread starter Thread starter magmike
  • Start date Start date
M

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.
 
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.
 
Back
Top