[Kelvin Lee]

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
Word MVP web site http://word.mvps.org


Kelvin Lee wrote:
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.