If-Then-Else

[NotMuchCode]

Hello. I have this (IF-THEN-ELSE) scheme that I can’t quite get right.

If TopTeamTotalActPts >= BottomTeamTotalActPts AND
If TopTeamAwayActPts >= BottomTeamHomeActPts Then
MsgBox “gotta take top team”

If BottomTeamTotalActPts >= TopTeamTotalActPts AND
If BottomTeamHomeActPts >= TopTeamAwayActPts Then
MsgBox “gotta take bottom team”

If neither of those conditions exist Then
MsgBox “pass on this game”

I’ve tried to figure this out using various combinations of (IF-THEN-ELSE), but I just don’t have an understanding of the code.
If anyone has a solution and wanted to share, it would be greatly appreciated.
Thank you.

[Mumps1]

Maybe:

Please Login or Register  to view this content.

[sintek]

I am assuming that the above is an explanation and not actual code...hence no code tags were placed

Please Login or Register  to view this content.

[DarkF1ame]

If this is going to be a table or something with a lot of entries there is also some potential of doing this in-cell and using conditional formatting to flag the games of interest.

Either way, if using VBA, other people were obviously faster than me. The main issue with your original post is that you don't need the second if, just input one argument, then "and" then the next argument all before the "Then".

[NotMuchCode]

Thanks very much (Mumps, sintek and DarkF1ame)

The code worked great and helped me a lot.

I can't seem to locate the "SOLVED" button.

[Mumps1]

Glad to help.
New Method
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved

Old Method
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

[sintek]

Pleasure...

[DarkF1ame]

You're most welcome. Heavy lifting done by others