Newbies emaclin Posted April 14, 2005 Newbies Posted April 14, 2005 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 Posted April 14, 2005 Posted April 14, 2005 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.
Newbies emaclin Posted April 14, 2005 Author Newbies Posted April 14, 2005 Thank you That realy shorted the calculation
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now