Convert number to text

[gnault]

Hey there,

I compiled several numbers in the field called "total". According to the "total", I would like to convert it to a grade (letter). If the total is between 90 and 100, A+ should be displayed in the field "grade". If it's between 85 and 90, A and so on. How do I do that ?

Gen

 

[Schlogg]

Define a calc field called Grade and use the Case function.

Case((Total <100) and (Total >= 90), &quot;A+&quot;,
(Total < 90) and (Total >=85), &quot;A&quot;,
etc.)

Paul J. Cheers,
Paul J.

 

[gnault]

Thanks schlogg,

it worked fine although I had to change the , to ;

Gen

 

[Schlogg]

Yes, the , and ; thing is a pain in the neck. The MAC separator is ; and the PC separator is ,. I flip flop between the two and it drives me insane.
Paul
Cheers,
Paul J.