Squee! I answered my own question.
{if {mergefield admittype}="HS" {if {mergefield evalcmp111}="2010" {if
{mergefield evalcmpvalue111}="80" {if {mergefield
evalcmpvalue111}"85" {includetext c:\\master_comment.doc
admission_award_80_to_84} ""} ""} ""} ""}
....with five more instances (using evalcmp111, 112, 113, etc) to
account for each case of 80.0-84.9% average. And then rinse, repeat,
and six more big IFs for the 85-89%.
Is there any difference between entering 80.0 and 80?
Go live is now in...8 days, 22 hours, 14 minutes. Me stressed?
Noooooo...
Heather
Heather wrote:
Me again. My merge questions just keep on coming.
I'm still working with IF and INCLUDETEXT statements to build admission
letters for students. I'm working on a statement that looks at the
admission average and determines which admission award to give. The
first range of averages would be from 80.0-84.9%, then 85.0-89.9%, and
then 90% and above. The averages reported appear in my gigantic (so
gigantor I can't open it in Excel) csv file. Here's the kicker - the
average can appear in one of six positions in the csv file.
So I've got this so far:
{if {mergefield admittype}="HS" {if {mergefield evalcmp111}="2010" {if
{mergefield evalcmpvalue111}="80"{if {mergefield
evalcmp111}="84.9"{includetext c:\\master_comment.doc
admission_award}""}""}""}""}
Which, naturally, isn't working when I test it...is it just my spacing?
Is there a better way to do this?
Thanks again for your help...it is greatly appreciated.
Heather