Need caculation to show invoice totals with a defined range

[HALBURN]

I am trying to create a "case" calculation in (FM7) that will return the invoice total if it is within the defined range.

How would I write a formula to show me an invoice total if it is in a range from "$251 to $500"?

[Søren Dyhr]

Is this a trick question, or...? Allright here's a little to choose from:

Case(aNumber>250 and aNumber<501;aNumber)

Case(not(aNumber ≤ 250 or aNumber ≥ 501);aNumber)

Case(aNumber ≤ 250 or aNumber ≥ 501 xor 1;aNumber)

Case(aNumber ≤ 250 or aNumber ≥ 501;Case(0;0);aNumber)

Case(Div ( aNumber-1 ; 250 )=1;aNumber)

--sd

[HALBURN]

Thanks Søren, you have gone over and above the call of duty!