nested if - Calculation field not working properly

[edddiec]

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." ;"")))))))

[comment]

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.

[edddiec]

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