Between Value

[#1]

Hi,

It's should be an easy task I can solve with some if but I'm sure there should be a function.

If I want just to compare some value with my range and know if my value it's between or not the range I've

(eg min 200 and max 400 and my value is 320. In this case my fucntion should reply YES)

Does it exist ? Without the requirement to use resident table with intervalmatch.

Thanks

[swuehl]

I think it is only one if-function you need:

if( Value >= Min and Value <= Max, 'Yes', 'No') as InRange

(for use in script, use > resp < if your Value needs to be inbetween min and max exclusive these limits)

or

=if( Value >= Min and Value <= Max, 'Yes', 'No')

as expression.

Hope this helps,

Stefan