Hi Folks - I'm pretty new to FM Pro so please excuse my ignorance!

 

I have a database for my students marks - from the marks I am using a nested if to generate a comment depending on the mark gained by the student - it works fine except for the students scoring <35% which it lists as "Although a narrow fail, this would suggest that major revision, past paper work and making use of Supported Study is a must if a Grade C pass is to be achieved." I can't figure out why it won't work - any help gratefully received

 

Happy New Year to All

Edddiec

 

the formula I used is listed below

 

If( GetAsNumber(Prelim 2012 overall %) >= 80;"This would suggest a Grade A pass. Past paper work and Supported Study would help to secure this grade." ;
If( GetAsNumber(Prelim 2012 overall %) >= 70;"This would suggest a Grade B /A pass. Past paper work and Supported Study would help achieve a Grade A pass." ;
If(GetAsNumber(Prelim 2012 overall %) >= 65;"This would suggest a Grade B pass. Past paper work and Supported Study would help secure a Grade B or possibly achieve a Grade A pass." ;
If(GetAsNumber(Prelim 2012 overall %) >= 60;"This would suggest a Grade C/ B pass. Past paper work and Supported Study would help secure a Grade B or possibly achieve a Grade A pass." ;
If( GetAsNumber(Prelim 2012 overall %)>= 50;"This would suggest a Grade C pass. Past paper work and Supported Study would help secure at least a Grade C." ;
If(GetAsNumber(Prelim 2012 overall %) ≤ 45 ;"Although a narrow fail, this would suggest that major revision, past paper work and making use of Supported Study is a must if a Grade C pass is to be achieved.";
If (GetAsNumber(Prelim 2012 overall %) ≤ 35;"This would suggest that Intermediate 1 is too much of a challenge and would suggest that Access 3 would be a more appropriate level for presentation." ;"")))))))

First, it would be much better to use the Case() function instead of nested Ifs.

 

Now, I believe the reason why it doesn't work the way you expect is that any score less than 35 is also less than 45 - and this condition is being evaluated first.

Thanks for the advice. Moved the second last and last statements and it now works ok

 

Will look at using the case () function next time

 

Edddiec