Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compound if statement
How do i make this work?
If Max = 39 Then dpdval = Roll15 _ Else Max = 59 Then dpdval = Roll2 _ Else Max = 89 Then dpdval = Roll3 _ Else Max 89 Then dpdval = Roll4 the Then in the first else statement is highlighted and I get an error Expected: end of statement |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
compound if statement
Hi,
Like this but be careful with the use of MAX, it's an excel keyword and you can get into triuble using it as a variable. Select Case Max Case Is = 39 dpdval = Roll15 Case Is = 59 dpdval = Roll2 Case Is = 89 dpdval = Roll3 Case Is 89 dpdval = Roll4 End Select Mike "Matthew Dyer" wrote: How do i make this work? If Max = 39 Then dpdval = Roll15 _ Else Max = 59 Then dpdval = Roll2 _ Else Max = 89 Then dpdval = Roll3 _ Else Max 89 Then dpdval = Roll4 the Then in the first else statement is highlighted and I get an error Expected: end of statement |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
compound if statement
"Matthew Dyer" wrote:
How do i make this work? You can use a Select statement, as MikeH suggests. Probably better. But all that is wrong with your statement is: you are missing If after each Else. Try: If Max = 39 Then dpdval = Roll15 _ Else If Max = 59 Then dpdval = Roll2 _ Else If Max = 89 Then dpdval = Roll3 _ Else If Max 89 Then dpdval = Roll4 ----- original message ----- "Matthew Dyer" wrote in message ... How do i make this work? If Max = 39 Then dpdval = Roll15 _ Else Max = 59 Then dpdval = Roll2 _ Else Max = 89 Then dpdval = Roll3 _ Else Max 89 Then dpdval = Roll4 the Then in the first else statement is highlighted and I get an error Expected: end of statement |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compound If, And Or - can | Excel Discussion (Misc queries) | |||
Compound IF statement | Excel Programming | |||
How do I write a compound if statement? | Excel Worksheet Functions | |||
compound | Excel Discussion (Misc queries) | |||
Problem with compound IF statement | Excel Worksheet Functions |