When creating Custom Fields for calculations, Empower gives us a bunch of operators. One of the trickiest (and honestly a bit confusing) is the RANGE operator.

Syntax:RANGE(Field,X,Y)

It’s meant to check if a value falls within certain limits — handy for Boolean fields like:

👉 Is Amount between 1.5 and 1.9?

If yes → “In spec”

If no → “Out of spec”

BUT here’s the catch:

If Field = X → ❌ outside the limits

If Field = Y → ✅ inside the limits

Yep, no typo. It’s weird and can easily cause unexpected results.

👉 My tip: Avoid using RANGE.

Instead, use a combination of comparison operators:

GTE(Field,X)&LTE(Field,Y)

This way both limits are clearly included – no surprises.

📌 Simple, reliable, and GMP-safe.