Using IF with MERGEFIELD

[stuart.collins]

Hi there

I'm having problems trying to do the following:

I have 4 fields, each with a 0 or 1, I want to be able to add these
fields together and base the output on if the total is >= 3.

First I started with adding them together:

{ «MG_Q1»+«MG_Q2»+«MG_Q3»+«MG_Q4» }

output: 0+1+1+1

I them made this in to a SUM:

{ =«MG_Q1»+«MG_Q2»+«MG_Q3»+«MG_Q4» }

output: 3

So far so good This gives me the sum of the four fields fine.

Now I need to have an output of YES or NO, depending on if the total

=3, so I put this (based on examples I've seen online):

{ IF{ =«MG_Q1»+«MG_Q2»+«MG_Q3»+«MG_Q4» } } >=3 "YES" "NO" }

Using this, I don't get any output at all

I've checked the data source and the fields are non-formatted etc, and
obviously add up OK (as with the second step) but seems I have the IF
clause incorrect.

Any help would be very greatly appreciated.... I'm starting to get
bumps on my head from banging it on the desk!

Many thanks

Stoo

 

[Doug Robbins - Word MVP]

Assuming that you used Ctrl + F9 to insert each pair of field delimiters and
that the superfluous } in

{ IF{ =«MG_Q1»+«MG_Q2»+«MG_Q3»+«MG_Q4» } } >=3 "YES" "NO" }

is just a typing error in composing your post, all you may need to do is
update the fields in the document.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

Hi there

I'm having problems trying to do the following:

I have 4 fields, each with a 0 or 1, I want to be able to add these
fields together and base the output on if the total is >= 3.

First I started with adding them together:

{ «MG_Q1»+«MG_Q2»+«MG_Q3»+«MG_Q4» }

output: 0+1+1+1

I them made this in to a SUM:

{ =«MG_Q1»+«MG_Q2»+«MG_Q3»+«MG_Q4» }

output: 3

So far so good This gives me the sum of the four fields fine.

Now I need to have an output of YES or NO, depending on if the total

=3, so I put this (based on examples I've seen online):

{ IF{ =«MG_Q1»+«MG_Q2»+«MG_Q3»+«MG_Q4» } } >=3 "YES" "NO" }

Using this, I don't get any output at all

I've checked the data source and the fields are non-formatted etc, and
obviously add up OK (as with the second step) but seems I have the IF
clause incorrect.

Any help would be very greatly appreciated.... I'm starting to get
bumps on my head from banging it on the desk!

Many thanks

Stoo

 

[stuart.collins]

Many thanks for a speedy reply Doug....

It's sorted thanks It was because I hadn't entered the delimiters
using ctrl+f9 and had typed them in myself... silly huh

Again, thanks...

Stoo