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

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
>

"Matthew Dyer" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message
news:e4cfcf10-b388-4de5-b0c5-(E-Mail Removed)...
> 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