[sims] SIMS Nested if then Else - Colour in Blank Cells

[LianneKemp]

Hi all, sorry if this has been posted elsewhere, I did do a quick check! I'm setting up some traffic light analysis in SIMS using the Nested if then Else formula. When i calculate the data in the marksheet, it will colour in blank cells as well. Can i do anything in the template to ignore or not colour blank cells?

Thanks!

Lianne

[vikpaw]

What does your formula tell it to do? Is it treating them as zero? Maybe add a final condition if anything else leave colourless.

[LianneKemp]

Thanks for replying, I actually worked out that is was my gradeset - I had a grade of 'N' which had a value of 11. I've amended my gradeset since and it works fine!