AnsweredAssumed Answered

Difficulty creating formula where CASE isn't working

Question asked by Jenim on Oct 14, 2013
Latest reply on Oct 15, 2013 by philmodjunk

Title

Difficulty creating formula where CASE isn't working

Post

      

We are trying to carry out the following

We have specific fields to work with

KSP

SEN

Baseline Eq

End of KS

      

We want to be able to use a calculation field called GRADE to work out the following (using CASE formula hasn’t worked)

Choose 1 from 3 types of SEN - PMLD, SLD, SLDHA (text)

If SEN = PMLD

If KSP = 0; “Miss”;

If KSP > 0.4; “Outstanding”;

If KSP > 0.3; “Good”;

“RImp”)

____________________

      

For SEN = SLD it is more complicated

If SEN = SLD

If KSP = 0; “Miss”;

If KSP > 0.6; “Outstanding”;

If KSP > 0.5; “Good”;

“RImp”)

      

BUT

      

If either Baseline Eq OR End of KS > 11

then

If SEN = SLD

If KSP = 0; “Miss”;

If KSP > 0.33; “Outstanding”;

If KSP > 0.3; “Good”;

“RImp”)

____________________

      

For SEN = SLDHA

If SEN = SLDHA

If KSP = 0; “Miss”;

If KSP > 0.8; “Outstanding”;

If KSP > 0.7; “Good”;

“RImp”)

      

BUT

      

If either Baseline Eq OR End of KS > 11

then

If SEN = SLD

If KSP = 0; “Miss”;

If KSP > 0.41; “Outstanding”;

If KSP > 0.33; “Good”;

“RImp”)

Outcomes