If-Then Calculations

[Debbie]

Hi Thomas,

This is from my earlier thread under the How, What, Where section.

It would be great if you could add if-then functionality to the Calculations section.

The example I used was...

Suppose I have a calculated field, Test Score, that can range from 0 to 100.

Now I want to output a Grade based on Test Score (or maybe a direction for the end user based on Test Score)...

For example, if Test Score < 60, Grade = F

if 61 < Test Score < 70, Grade = D

and so on.

Thanks,
Debbie