Counting If between numbers

[infock12]

Hi All,

I am using a straight table and trying to multiple two columns and add background colour based on the results.

The expression is Maths * English

In the "Background Colour" Section under expressions, I added,

=IF(Maths * English>12, LightRed(),
if(Maths * English<=12 and if(Maths * English>=8, LightMagenta()), LightGray())).

The first If works (>12 changes to LightRed()). However, LightGray() appears for the second category, i.e., values between 8 and 12. LightMagenta does not appear anywhere. Values below 8 has no background colour, appears in white. What am I doing wrong please?

Regards,

Karthik

[rubenmarin · Accepted solution]

Hi Karthik, try with this:

=IF(Maths * English>12, LightRed(),

   if(Maths * English>=8, LightMagenta(), LightGray())).

[infock12]

Hi Ruben,

Yes, it works. Thank you very much!