| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
else if code
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
else if code
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
| Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
| Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
| Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
| VBA code delete code but ask for password and unlock VBA protection | Excel Programming | |||
Linear Mode
