IF statement - number range

[irhut]

Hello All,

This is a fantastic forum and has been very useful with helping me to learn about all things mailmerge.

I have (hopefully) a very simple problem that is really annoying:

I know how to use use basic rules in a mail merge and have been using the IF command. I am trying to get word to place a star in a box depending on the value of a merge field (Percentage Attendance) . So if the value is greater than 95% it puts a star in the top box. This bit is easy using a simple if command:

{IF {MERGGEFIELD percentage_attendance}>= 95 "*"}

However where I am having a trouble is the next box down where I want a star to appear when the Percentage Attendance is between 90 and 94.9% How do I get the IF statement to compare percentage attendance to a range of numbers? I want something like:

{IF {MERGGEFIELD percentage_attendance}= 90-94.9 "*"}


This obviously does not work and despite spending ages looking online I can't find how to do it.

Obviously if I just use

{IF {MERGGEFIELD percentage_attendance}>= 90 "*"}


It will put a star in the box for numbers higher than 95 which I do not want.



Any help would be much appreciated - I am hoping there is a simple answer!

Ian