Introduction

Here's another scenario where a NESTED-IF-THEN-ELSE formula can be used to add colour to a marksheet. In this example we will use a NITE formula to apply colours based on the grade given to a pupil.

The key thing to remember when using a NITE formula with a grade aspect is that the formula uses the numeric value provided by the grade set behind the grade, not the grade itself.

Still Confused?

Use the comments section below to ask a question.