IF, AND Formulas

[candyyoung]

I am just learning Excel and I am trying to add a formula to some cell
to do multiple functions. Here is what I am trying to do: IF B1=1 an
C1=1, add "1" to A1 and delete B1 and C1. Any help out there

 

[Guest]

Since you are trying to change three cells you will need a macro rather than
a function. Try the following:

Sub bumpandclear()
If Cells(1, 2) = 1 And Cells(1, 3) = 1 Then
Cells(1, 1) = Cells(1, 1) + 1
Cells(1, 2) = ""
Cells(1, 3) = ""
End If
End Sub

 

[Bob Phillips]

You can't do that with a formula. A formula exists in one cell, and returns
a value to just one cell, and you cannot add 1 to itself.

Secondly, if you clear out B1, the formula in A1 won't work any longer.


--

HTH

RP
(remove nothere from the email address if mailing direct)