Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following if/Then statements
If affirmation = "" Then If indirect = "" Then If direct = "" Then CalPrac = "NI" ElseIf direct = "x" Then CalPrac = "PI" ElseIf direct = "w" Then CalPrac = "PI" ElseIf direct = "m" Then CalPrac = "NI" ElseIf direct = "ny" Then CalPrac = "NY" End If ElseIf indirect = "x" Then If direct = "" Then CalPrac = "PI" ElseIf direct = "x" Then CalPrac = "FI" ElseIf direct = "w" Then CalPrac = "LI" ElseIf direct = "m" Then CalPrac = "PI" ElseIf direct = "ny" Then CalPrac = "NY" End If ElseIf indirect = "m" Then <~~Compile error, else without if If direct = "" Then CalPrac = "NI" ElseIf direct = "x" Then CalPrac = "PI" ElseIf direct = "w" Then CalPrac = "PI" ElseIf direct = "m" Then CalPrac = "NI" ElseIf direct = "ny" Then CalPrac = "NY" End If End If ElseIf affirmation = "x" Then If indirect = "" Then If direct = "" Then CalPrac = "NI" ElseIf direct = "x" Then CalPrac = "FI" ElseIf direct = "w" Then CalPrac = "LI" ElseIf direct = "m" Then CalPrac = "NI" ElseIf direct = "ny" Then CalPrac = "NY" End If ElseIf indirect = "x" Then If direct = "" Then CalPrac = "PI" ElseIf direct = "x" Then CalPrac = "FI" ElseIf direct = "w" Then CalPrac = "LI" ElseIf direct = "m" Then CalPrac = "PI" ElseIf direct = "ny" Then CalPrac = "NY" End If ElseIf indirect = "m" Then If direct = "" Then CalPrac = "NI" ElseIf direct = "x" Then CalPrac = "FI" ElseIf direct = "w" Then CalPrac = "LI" ElseIf direct = "m" Then CalPrac = "NI" ElseIf direct = "ny" Then CalPrac = "NY" End If End If End If I've noted where the error is. I just don't see it. I'm sure another pair of eyes will find it. Thanks, Barb Reinhardt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
#missing! | Excel Worksheet Functions | |||
Missing OCX or DLL... | Excel Programming | |||
Toolbars Missing, And option to Add Missing | Excel Discussion (Misc queries) | |||
On Error? Creates 1 missing worksheet then never detects any other missing worksheets | Excel Programming | |||
What am I missing here....? | Excel Programming |