Test if field value is in a range?

[Lange]

Hi

I'm trying to define a field with a calculation like this:

If ("value of my field is between 600 and 1000 - do this - else do this")

I think it can be done with the If(test:result one:result two) but how do I test if my field value in a range? It is probably quite obvious.

[Steven H. Blackwell]

Try:

(my_field > 600 and my_field <800)