Transmutation Formula

Syntax

=IF ( “TOT SCORE OF THE STUDENT “ >= (“PERFECT SCORE”/2), ROUND(25/(“PERFECT SCORE”/2)*”TOT SCORE OF THE STUDENT”+50,0), ROUND(15/(“PERFECT SCORE/2)* “TOT SCORE OF THE STUDENT” +60,0))

Example

 =IF(AB15>=($AB$14/2),ROUND(25/($AB$14/2)*AB15+50,0),ROUND(15/($AB$14/2)*AB15+60,0))