Mark in Rank.

[Guest]

I have a table with content of Name, Mark and Rank

What's formular for me to get the result in Rank if I input 80 or above in
Mark, and it will get me as "A", if I input between 40 to 20, it will shown
"D" in Rank.

Thank you.

 

[Graham Mayor]

Assuming the Mark entry is bookmarked then

{ IF{ REF Mark } >= 80 "A" "{ IF{ REF Mark } <= 40 "{ IF{ REF Mark } >= 20
"D" "" }" "" }" }

This doesn't do anything below 20 or between 41 and 79


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>