Susan01

Damn.. just hit the column limit :-(

Thank you very much! I’m trying to create a RAG marksheet that takes the resultsof a set of tasks/KPI’s/whatever they end up being called, and calculates anoverall value for Mastery, Secure, Developing or Emerging as follows: IF >=90% green AND any mastery task green THEN M ELSE IF >=60% green THEN S ELSE IF >=30% green or amber THEN D ELSE E Anyway, I started typing out what I've been trying to do, and in the process realised how I could omit the nested, nested-ifs by changing things around a bit - and ... success at last! Thanks John btw for your solution. It's more complex than I needed (I used two IF X then 1 else 0 statements, then multiplied them together), but it will be stored away for future use.

Can someone tell me - in a marksheet, can I use nested if in 'Add a column for Data Review' then use the result in another nested if in a second 'add a column for data review'? I've tried setting this up, but when I try to create the second one, it's not showing the first as an available column for the calculation. If only there was an option for IF x AND y then ... life would be a lot simpler and I wouldn't be banging my head off the wall right now!

Huge thank you for this reply! I've had the exact same problem and have been tearing my hair out over it. And there you go, I had forgotten to allocate the pupils into their D&T sets - problem solved!!!