# 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”)