![]() |
|
#2
|
||||
|
||||
|
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] |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Need help with If, Then Statement Please
|
cangelis | Excel | 4 | 01-03-2014 09:10 AM |
Choose color for different number range
|
secoo140 | Excel | 9 | 10-07-2013 12:12 PM |
Help with IF Statement
|
limpbizkit | Excel | 4 | 02-24-2011 09:16 PM |
if statement
|
piper7971 | PowerPoint | 1 | 08-19-2010 07:10 AM |
Help with IF statement!
|
CPelkey | Word | 1 | 04-12-2010 09:06 AM |