Thread: else if code
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Juan Pablo González Juan Pablo González is offline
external usenet poster
 
Posts: 226
Default else if code

Try something like this

If Application.Sum(Range("AL2,AL4,AL6,AL8")) < Range("AP12").Value Then
MsgBox "Your message here"
Else
SubmitAll
If Range("AL2").Value 0 Tjhen
SubmitAllCash
End If
End If

--
Regards,

Juan Pablo González

"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