two "ifs" in one calculation ?

[smith]

New to FileMaker - trying to calculate fields based on two variables: for a school math assessment database I want to set some fields that will return certain numbers if two things happen - if the year is "xxxx" and if the grade level is "xxxx" then the certain fields will equal specific values. I started with a Case calculation for each of those certain fields, but then I realized that those results would only be good for one year. I didn't know how to make the results be possibly different in different years.

If the Benchmark Level is gr3, then Number Sense would be equal to 6, but how would I write it to be if the year is 2003-2004 and the Benchmark Level is gr3, then Number Sense would be equal to 6. If the year is 2004-2005 and the Benchmark Level is gr3, then Number Sense is equal to 7. Please help.

Forum Help.zip

[Lee Smith]

Assuming your "year" and "Benchmark Level" fields are both text, and that your data in those fields are 2003-2004, 2004-2005, gr3

Number Sense calculation would look like this.

Case(year = "2003-2004" and Benchmark Level = "gr3" , 6,

year="2004-2005" and Benchmark Level = "gr3", 7)

HTH

Lee