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
--
Gary's Student


"candyyoung" wrote:


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


--
candyyoung
------------------------------------------------------------------------
candyyoung's Profile: http://www.excelforum.com/member.php...o&userid=26795
View this thread: http://www.excelforum.com/showthread...hreadid=400470