Parsing a string into numeric values

X < Y < X

That one is not possible.

The Split function will parse the comma delimited string into substrings, which you can coerce to numeric values using CDbl() or similar function. Then you can perform whatever calculations are appropriate using a Case statement. If you clarify your question, I or someone else will help.

To clarify:

For example: txtval (string) will store the following values:

1, 2, 3, 4 = txtval

My range is anything greater than or equal to 2 or less than or equal to 4.

Therefore, my calculation would be as follows:

X = [Sum those numbers that fall within the range] / [sum of all numbers]

X = 2 + 3 + 4 / 10

X = 9/10

X = 0.9

So I guess my question is how do I take txval and 'break' it back into individual numbers that I can use in my calculations.

My fault I caused some confusion when describing the range as

X<Y< X

It should be X<Y<Z.

Thank you

Hi

How about creating a function to do the calculation, and working from there.

In the code below, I've dummied up a string with comma separated values. the function takes that string, a lower number and an upper number and returns the result.

Please Login or Register  to view this content.

Hope that gets you going.


rylo

Thanks Rylo, I'll give that a try later today and get back to you.

Cheers!

I was able to get a variation of your code working, thank you for your help! No I just have to try and shake this rust off!

Cheers!

Hi

Care to share your final working solution with the forum???


rylo