Setting ranges for comparison operators

**dems** · 07-21-2009, 08:06 PM

Hi everyone,

Is it possible to set a range using comparison operators? ie. if a number lies within x and y then such and such happens.

To be more precise:

Please Login or Register  to view this content.

Focusing on the red text, I was hoping to set english and science so that they are also < 70 (lie between 50 - 69).

Thanks for your time!

**shg** · 07-21-2009, 08:23 PM

Not sure of the logic you're trying to apply. Maybe this:

Please Login or Register  to view this content.

**broro183** · 07-21-2009, 08:43 PM

hi Dems,

I think you have given the answer to your own question in your example (once corrected by changing the red "70" to a "50")...?

Here's a very slightly alternative approach to your function, using Long for the arguments which may be slightly faster for large data sets, because I think that Double is "overkill". Note that the order of the tests in the function means that the range of 50-69 is already "defined" within the second Case, because the arguments have failed the initial test (ie ">=70") but do pass the ">50" test.

Please Login or Register  to view this content.

If you need more help let us know

hth
Rob

**broro183** · 07-21-2009, 08:59 PM

Shg, you beat me to it again - good to see that I'm starting to think similarly to yourself though

Although, I do like your use of the .min function because this would mean changes would only need to be made in the Function's arguments & the .min line of code if (or when) the function is modified to allow for more subjects.

Rob

**shg** · 07-21-2009, 11:00 PM

I dunno, Rob, don't know what the OP is trying to do. Many roads lead to Rome.

**dems** · 07-22-2009, 10:13 AM

Thanks gentlemen, you have been verty helpful! I will definately spend some time reading further into case statements and worksheetfunction.min/max, but both yield the result I was looking for, which was to analyse 3 test results and report a grade in relation to the test results. Once more, thank you.