Prev: IP address to Hostname in Excel
Next: Compile error. Need Help with this UDF !!!!!!!!!!!!!!!
From: Dave Peterson on 11 Apr 2010 15:46
I wouldn't use both end points.

I'd just check to see what it was less than (or less than or equal to):

Select Case Delta1ToSP
Case is <= -0.10 'that last 0 will disappear, but I kept it here!
Stop
Case is <= -0.05
Stop
Case is <= -0.02
Stop
Case is <= 0.05
Stop
Case is <= 0.10
Stop
Case is <= 1
Stop
Case Else
Stop
End select

The first case that matches is the one that is used.

And I don't have to worry about what happens at -0.0500000001



David wrote:
>
> Hello Group,
>
> I have a select case that is not working as I expected, Delta1ToSP =
> -3.38629648094637E-02 or -.0338:
>
> Select Case Delta1ToSP
> Case -0.02 To -0.05 ' This is where I expected the stop
> Stop
> Case -0.050001 To -0.1
> Stop
> Case -0.10001 To -1
> Stop
> Case 0.02 To 0.05
> Stop
> Case 0.050001 To 0.1
> Stop
> Case 0.10001 To 1
> Stop
> Case Else
> Stop
> End Select
>
> What am I missing?
>
> Thanks,
> --
> David

--

Dave Peterson
From: Rick Rothstein on 11 Apr 2010 20:20
It's mentioned in the Description for "expressionlist-n" (4th sentence) in
the table with the Part/Description heading.

--
Rick (MVP - Excel)



"David" <David(a)discussions.microsoft.com> wrote in message
news:BDC87DC9-E4A9-40EA-9FF5-2FC3EB550594(a)microsoft.com...
>
> Thank you all. When I read through help, I don't think this was mentioned.
>
> "Don't be too hard on yourself - it is Sunday!" Space, the final frontier,
> lol.
>
> --
> David
>
>
> "Rick Rothstein" wrote:
>
>> You must put the smaller value on the left of the "To" keyword and the
>> larger value on the right...
>>
>> Select Case Delta1ToSP
>> Case -0.05 To -0.02 ' This is where I expected the stop
>> Stop
>> Case -0.050001 To -0.1
>> Stop
>> Case -1 To -0.10001
>> Stop
>> Case 0.02 To 0.05
>> Stop
>> Case 0.050001 To 0.1
>> Stop
>> Case 0.10001 To 1
>> Stop
>> Case Else
>> Stop
>> End Select
>>
>> --
>> Rick (MVP - Excel)
>>
>>
>>
>> "David" <David(a)discussions.microsoft.com> wrote in message
>> news:2FE79046-53B3-41F6-AAAB-133A0ED132FB(a)microsoft.com...
>> > Hello Group,
>> >
>> > I have a select case that is not working as I expected, Delta1ToSP =
>> > -3.38629648094637E-02 or -.0338:
>> >
>> > Select Case Delta1ToSP
>> > Case -0.02 To -0.05 ' This is where I expected the stop
>> > Stop
>> > Case -0.050001 To -0.1
>> > Stop
>> > Case -0.10001 To -1
>> > Stop
>> > Case 0.02 To 0.05
>> > Stop
>> > Case 0.050001 To 0.1
>> > Stop
>> > Case 0.10001 To 1
>> > Stop
>> > Case Else
>> > Stop
>> > End Select
>> >
>> > What am I missing?
>> >
>> > Thanks,
>> > --
>> > David
>>
>> .
>>
First  |  Prev  | 
Pages: 1 2
Prev: IP address to Hostname in Excel
Next: Compile error. Need Help with this UDF !!!!!!!!!!!!!!!