Thread: compile error: block if without end if
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
jgett jgett is offline
external usenet poster
  
Posts: 1
Default compile error: block if without end if
whelanj,

The correct syntax is

If Utilization 90 Then
UtilizationRank = 1
ElseIf Utilization <= 90 And Utilization 75 Then
UtilizationRank = 2
...
End If


---
Message posted from http://www.ExcelForum.com/

Reply With QuoteReply With Quote