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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Leave final cell blank 2
#REF! 1
ISBLANK IF STATEMENT 6
If 0 then blank 8
Counting formula 1
If Formula 10
Sumproduct in matrix means 3
I need a formula to add numbers to the result in same cell. 1

Back
Top