View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matthew Dyer Matthew Dyer is offline
external usenet poster
 
Posts: 178
Default 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