"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