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

I have an intro course with C++ but a newbie user with VB. I googled th
error, which seems pretty simple in itself, but I didn't resolve it
The error is:

*Block If without End If*

and the code, copied right out of VB:


Function UtilizationRank(Utilization As Integer) As Integer

If Utilization 90 Then
UtilizationRank = 1
If Utilization <= 90 And Utilization 75 Then
UtilizationRank = 2
If Utilization <= 75 And Utilization 50 Then
UtilizationRank = 3
If Utilization <= 50 And Untilization <= 1 Then
UtilizationRank = 4
If Utilization = 0 Then
UtilizationRank = 5
End If

End Function



Like I said, newbie prob. I'm not sure about whitespace issues either
Solve my problem, give me pointers. Thanks

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