Case or If ?

[emaclin]

Hello,

And thank you in advance

I'm trying to simplify a Case calculation in Filemaker pro 5. I have two fields: Score and grade. I would like the grade to automaticly appear when I enter the score. The calculation I've created works fine, but I would like to know if it is a easier way. In my calculation I have to enter every number, for example: 60 = D, 61 = D and so on is there a way to say from 60 to 65 = D

Your help is much appreciated

thx [email protected]

[comment]

To answer your question literally:

Case (

60 <= Score and Score <= 65 , "D"

)

I suppose a more efficient scheme is possible - but for that we would need to know the rest of the rules for determining the grade from score.

[emaclin]

Thank you

That realy shorted the calculation