Check Values in If Then

[DCooper]

I'm a newbie here and can't figure out how to make this work, and I have tried other variations to no avail...
If TotalA = 0 To 0.304 Then
Msgbox("2","Recommended Size")
Else If TotalA = 0.305 to .500 Then
Msgbox("3","Recommended Size")
End If

Thanks!

 

[JonPM]

If TotalA >= 0 AND TotalA <= 0.304 Then
Msgbox("2","Recommended Size")
Else If TotalA >= 0.305 AND TotalA <= .500 Then
Msgbox("3","Recommended Size")
End If
End If

 

[timwil]

How about this:

   If (Total >=0) And (Total<= 0.304) Then
      .....do whatever

   Else If (Total >=0.305) And (Total<= 0.5) Then
      .....do whatever

   Else
      .....do whatever

   End If

 

[klaus]

I would change it to this:

   If (TotalA >= 0) And (TotalA <= 0.304) Then
      .....do whatever

   Else If (TotalA > 0.304) And (TotalA <= 0.5) Then
      .....do whatever

   Else
      .....do whatever

   End If

Because if the value of Total = 0.3045 then it would have been in the Else section.

Best regards

 

[DCooper]

I would change it to this:

   If (TotalA >= 0) And (TotalA <= 0.304) Then
      .....do whatever

   Else If (TotalA > 0.304) And (TotalA <= 0.5) Then
      .....do whatever

   Else
      .....do whatever

   End If

Because if the value of Total = 0.3045 then it would have been in the Else section.

Best regards

Thank you so much! It worked like a charm.

 

[kickaha]

why not remove TotalA > 0.304 from the Else If, as we know that it is if it got to that line.

   If (TotalA >= 0) And (TotalA <= 0.304) Then
      .....do whatever

   Else If TotalA <= 0.5 Then
      .....do whatever

   Else
      .....do whatever

   End If

 

[tremara1]

not covering the range

I believe values in the first evaluation will be included in the second evaluation, it does not limit the overall evaluation to the range required.

 

[kickaha]

I believe values in the first evaluation will be included in the second evaluation, it does not limit the overall evaluation to the range required.

No, if TotalA <= 0.304 then the second evaluation is never processed, so no need to check there if it is >0.304, as it must be (the clue is in the word ELSE).

If you need confirmation, try running this code

TotalA = 0.2

If (TotalA >= 0) AND (TotalA <= 0.304) Then      
   Log (">0 <=0.304")   
   Else If TotalA <= 0.5 Then  
      Log (">0.304 <=0.5")
   Else     
      Log (">0.5")
End If

and alter TotalA, you will find only one of the logs can trigger, never two.