=5*IF(OR(C4="F";C4="N"); 2+IF(F4>60;2;1);0)

Please, what this expression means!"

The formula means IF cell C4 has text F or N, then use the next condition, otherwise set it to zero (5*0=0). When C4 equals to F or N then if F4 is greater than 60, use value 2 which means the total is 5*(2+2), otherwise (i.e. F4 less than or equal to 60) use value 1 which means the total is 5*(2+1)

Therefore the valid results are 0, 15 or 20.

Hope this helps…

@Pedro1 - edited to escape asterisks, which weren’t being rendered in the initial format. Very nice explanation. :slight_smile: