If Statement - replacing two cells

[techgirl]

I need to know how to use an If statement for the following scenario...
If A1 = 0, the replace the entries in C1 and E1 with 0.

 

[Joe4]

Here is the section of VBA code to do that.

If Range("A1")=0 Then
    Range("C1")=0
    Range("E1")=0
End If

 

[techgirl]

Is there a formula instead of VBA Code??

 

[Scott Huish]

A formula can not replace the contents of other cells.
If there are formulas in C1 and E1, you can incorporate this into the formula. If so, please post these formulas, if not you will need VBA.

 

[Joe4]

You cannot store both a value and a cell in the same cell in Excel, and Excel formulas can only update values in the cells they are found in (they cannot update other cells directly).

So you either need to use VBA, or re-think how you want to do this.

 

[daniels012]

You would have to have in Cells C1 and E1 a formula!
Like in cell C1:
=IF(A1=0,0,other condition)

Michael

 

[orbea_adam]

I need to know how to use an If statement for the following scenario...
If A1 = 0, the replace the entries in C1 and E1 with 0.

Do C1 and E1 have formulas already? If so, then: =IF(A1=0,0,your current formula)
If C1 and E1 and hard-typed entries, then I agree with the others

 

[techgirl]

C1 and E1 had nothing in them. I have added the following in each cell and worked great.

C1 =IF(A1=0,0,A1*B1)
E1 =IF(C1=0,0,C1+D1)

Thanks so much!

 

[orbea_adam]

Excellent!