Number Ranges

[ktstem]

How do I do incorporate number ranges into a calculation? For example, Score = 15 to 25, Result = Advanced. I'm stuck!

Kate

[stanley]

Kate:

The syntax for a range in FileMaker is "..." so in your example you'd put in "15...25". It works for dates, too.

-Stanley

[MoonShadow]

Your calculation would be text and would look something like:

Case(Score > 14 and Score <= 25, "Advanced")

You can expand or adjust this accordingly:

Case(Score <= 10, "Beginner", Score <= 15, "Intermediate", Score <= 25, "Advanced", "Guru")

[ktstem]

Thank you! I knew I was missing something. I was thinking the same thing as Stanley did above, to use the "..." for range.

Kate

[stanley]

Kate:

My mistake - I didn't see you were asking about a calculation & gave you old-hat "find" advice...

-Stanley

[ktstem]

Oh that is OK!