If Worksheetfunction.Sum(Range("AL2,AL4,AL6,AL8")) < Range("AP12") Then
Msgbox ..........
ElseIf Range("AL2") 0.01 Then
SubmitALLcash
Else
SubmitAll
End If

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"choice" wrote in message
...
i have a code that says:
If Range("AL2,AL4,AL6,AL8") = Range("AP12") Then
SubmitAll

ElseIf Range("AL2") 0.01 Then
submitALLcash

Else
Ms
what i want to happen is if the sum of "AL2,AL4,AL6,AL8 is less then AP12
msgbox to appear, if it is greater then ap12, then SubmitALL
also is everything is greater and AL2 is greater then 0, i want
SubmitALLcash to go

please help