View Single Post
 
Old 02-11-2014, 11:20 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,496
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You could simply nest the fields, as in:
{IF {MERGEFIELD percentage_attendance}>= 95 "*" {IF {MERGEFIELD percentage_attendance}>= 90 "**"}}
or:
{IF {MERGEFIELD percentage_attendance}< 90 "" {IF {MERGEFIELD percentage_attendance}< 95 "**" "*"}}

You could even forego the IF test entirely, with:
{=(INT({MERGEFIELD percentage_attendance}/5)-18) \# "'*';;'**'"}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote