i have a code that says
If Range("AL2,AL4,AL6,AL8") = Range("AP12") The
SubmitAl

ElseIf Range("AL2") 0.01 The
submitALLcas

Els
M
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 SubmitAL
also is everything is greater and AL2 is greater then 0, i want SubmitALLcash to g

please help