Select Case

[IanT]

Hi

I am using the code below to idntify minus figures, the code does not pick the minus figures up, any ideas why!

Function IncurredBand(Incurred)

Select Case Incurred
Case -1 To -500
IncurredBand = -500

Case -501 To -5000
IncurredBand = -5000

Case -5001 To -15000
IncurredBand = -15000


Case Else
IncurredBand = Incurred



End Select


End Function

 

[Brianwarnock]

The smallest value must come first

Case -500 To -1


Brian

 

[DCrake]

Try this

Function IncurredBand(Incurred)

Select Case Incurred
    Case -500 To -1
        IncurredBand = -500
    Case -500 To -501
        IncurredBand = -5000
    Case -15000 To -5001
        IncurredBand = -15000
    Case Else
        IncurredBand = Incurred
End Select

End Function

Had your negative the wrong way round

 

[Brianwarnock]

Had your negative the wrong way round

I said that

Brian

 

[boblarson]

Had your negative the wrong way round

I said that

Brian

No you didn't

The smallest value must come first

Looks like different words to me.

(sorry, couldn't help myself - I know you MEANT the same thing)

 

[Brianwarnock]

No you didn't


Looks like different words to me.

(sorry, couldn't help myself - I know you MEANT the same thing)

That's ok Bob it emphasises how more explanatory my words are, it states why they are the wrong way round.

Brian