Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 7232 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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]

Posted

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.

This topic is 7232 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.