IF statement not working

I have a form where the user enters the number of reports for the current
year as well as the number of reports for the previous year. I want to use
this information to automatically tell the user whether the number of reports
has increased or decreased.

REPTotal is the total reports for the current year
PrevYearREP is the number of reports for the previous year.

Here is the IF statement I am using:

{ IF (REPTotalPrevYearREP "an increase" "a decrease") }

I don't anticipate the numbers ever being the same. For some reason, no
matter what numbers I use, the field ALWAYS displays "an increase". The field
is not locked, and I have been updating it after changing the numbers.

What am I doing wrong?

Assuming that REPTotal and PrevYearREP are global variables or bookmarks,
they must be inserted as REF fields in your code:

{ IF { REPTotal } { PrevYearREP } "an increase" "a decrease" }

Also, note that each pair of field delimiters, { }, must be added by
pressing Ctrl+F9.

--
Stefan Blom
Microsoft Word MVP



"CPelkey" wrote in message
...
I have a form where the user enters the number of reports for the current
year as well as the number of reports for the previous year. I want to use
this information to automatically tell the user whether the number of
reports
has increased or decreased.

REPTotal is the total reports for the current year
PrevYearREP is the number of reports for the previous year.

Here is the IF statement I am using:

{ IF (REPTotalPrevYearREP "an increase" "a decrease") }

I don't anticipate the numbers ever being the same. For some reason, no
matter what numbers I use, the field ALWAYS displays "an increase". The
field
is not locked, and I have been updating it after changing the numbers.

What am I doing wrong?

Stefan, thanks for your reply!

I tried inserting the references using Ctrl+F9, but now instead of giving a
result, it comes back with the contents of the first reference. So whatever
number is in REPTotal displays in the field instead of either of the text
values =(

Is there anything else you can think of?

"Stefan Blom" wrote:

Assuming that REPTotal and PrevYearREP are global variables or bookmarks,
they must be inserted as REF fields in your code:

{ IF { REPTotal } { PrevYearREP } "an increase" "a decrease" }

Also, note that each pair of field delimiters, { }, must be added by
pressing Ctrl+F9.

--
Stefan Blom
Microsoft Word MVP



"CPelkey" wrote in message
...
I have a form where the user enters the number of reports for the current
year as well as the number of reports for the previous year. I want to use
this information to automatically tell the user whether the number of
reports
has increased or decreased.

REPTotal is the total reports for the current year
PrevYearREP is the number of reports for the previous year.

Here is the IF statement I am using:

{ IF (REPTotalPrevYearREP "an increase" "a decrease") }

I don't anticipate the numbers ever being the same. For some reason, no
matter what numbers I use, the field ALWAYS displays "an increase". The
field
is not locked, and I have been updating it after changing the numbers.

What am I doing wrong?


.

How did you create the starting and closing braces? These must also be
inserted via Ctrl+F9 (or via the Field dialog box of course); otherwise you
haven't got a working IF field construct.

--
Stefan Blom
Microsoft Word MVP



"CPelkey" wrote in message
...
Stefan, thanks for your reply!

I tried inserting the references using Ctrl+F9, but now instead of giving
a
result, it comes back with the contents of the first reference. So
whatever
number is in REPTotal displays in the field instead of either of the text
values =(

Is there anything else you can think of?

"Stefan Blom" wrote:

Assuming that REPTotal and PrevYearREP are global variables or bookmarks,
they must be inserted as REF fields in your code:

{ IF { REPTotal } { PrevYearREP } "an increase" "a decrease" }

Also, note that each pair of field delimiters, { }, must be added by
pressing Ctrl+F9.

--
Stefan Blom
Microsoft Word MVP



"CPelkey" wrote in message
...
I have a form where the user enters the number of reports for the
current
year as well as the number of reports for the previous year. I want to
use
this information to automatically tell the user whether the number of
reports
has increased or decreased.

REPTotal is the total reports for the current year
PrevYearREP is the number of reports for the previous year.

Here is the IF statement I am using:

{ IF (REPTotalPrevYearREP "an increase" "a decrease") }

I don't anticipate the numbers ever being the same. For some reason, no
matter what numbers I use, the field ALWAYS displays "an increase". The
field
is not locked, and I have been updating it after changing the numbers.

What am I doing wrong?


.

Yes, I am using Ctrl+F9 to enter all fields. I have several fields in the
document that all work perfectly well, but none of the If-Then-Else
statements I use seem to work. There must be some kind of syntax error I am
making, I just don't have the experience to be able to find it.


"Stefan Blom" wrote:

How did you create the starting and closing braces? These must also be
inserted via Ctrl+F9 (or via the Field dialog box of course); otherwise you
haven't got a working IF field construct.

--
Stefan Blom
Microsoft Word MVP



"CPelkey" wrote in message
...
Stefan, thanks for your reply!

I tried inserting the references using Ctrl+F9, but now instead of giving
a
result, it comes back with the contents of the first reference. So
whatever
number is in REPTotal displays in the field instead of either of the text
values =(

Is there anything else you can think of?

"Stefan Blom" wrote:

Assuming that REPTotal and PrevYearREP are global variables or bookmarks,
they must be inserted as REF fields in your code:

{ IF { REPTotal } { PrevYearREP } "an increase" "a decrease" }

Also, note that each pair of field delimiters, { }, must be added by
pressing Ctrl+F9.

--
Stefan Blom
Microsoft Word MVP



"CPelkey" wrote in message
...
I have a form where the user enters the number of reports for the
current
year as well as the number of reports for the previous year. I want to
use
this information to automatically tell the user whether the number of
reports
has increased or decreased.

REPTotal is the total reports for the current year
PrevYearREP is the number of reports for the previous year.

Here is the IF statement I am using:

{ IF (REPTotalPrevYearREP "an increase" "a decrease") }

I don't anticipate the numbers ever being the same. For some reason, no
matter what numbers I use, the field ALWAYS displays "an increase". The
field
is not locked, and I have been updating it after changing the numbers.

What am I doing wrong?


.




.

Have you selected the field and pressed F9 to update it?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"CPelkey" wrote in message
...
Yes, I am using Ctrl+F9 to enter all fields. I have several fields in the
document that all work perfectly well, but none of the If-Then-Else
statements I use seem to work. There must be some kind of syntax error I
am
making, I just don't have the experience to be able to find it.


"Stefan Blom" wrote:

How did you create the starting and closing braces? These must also be
inserted via Ctrl+F9 (or via the Field dialog box of course); otherwise
you
haven't got a working IF field construct.

--
Stefan Blom
Microsoft Word MVP



"CPelkey" wrote in message
...
Stefan, thanks for your reply!

I tried inserting the references using Ctrl+F9, but now instead of
giving
a
result, it comes back with the contents of the first reference. So
whatever
number is in REPTotal displays in the field instead of either of the
text
values =(

Is there anything else you can think of?

"Stefan Blom" wrote:

Assuming that REPTotal and PrevYearREP are global variables or
bookmarks,
they must be inserted as REF fields in your code:

{ IF { REPTotal } { PrevYearREP } "an increase" "a decrease" }

Also, note that each pair of field delimiters, { }, must be added by
pressing Ctrl+F9.

--
Stefan Blom
Microsoft Word MVP



"CPelkey" wrote in message
...
I have a form where the user enters the number of reports for the
current
year as well as the number of reports for the previous year. I want
to
use
this information to automatically tell the user whether the number
of
reports
has increased or decreased.

REPTotal is the total reports for the current year
PrevYearREP is the number of reports for the previous year.

Here is the IF statement I am using:

{ IF (REPTotalPrevYearREP "an increase" "a decrease") }

I don't anticipate the numbers ever being the same. For some reason,
no
matter what numbers I use, the field ALWAYS displays "an increase".
The
field
is not locked, and I have been updating it after changing the
numbers.

What am I doing wrong?


.




.

Hi CPelkey,

Instead of an IF test, try something along the lines of:
{={ REPTotal }-{ PrevYearREP } \# "'an increase';'a decrease';'no change'"}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[Microsoft MVP - Word]


"CPelkey" wrote in message ...
I have a form where the user enters the number of reports for the current
year as well as the number of reports for the previous year. I want to use
this information to automatically tell the user whether the number of reports
has increased or decreased.

REPTotal is the total reports for the current year
PrevYearREP is the number of reports for the previous year.

Here is the IF statement I am using:

{ IF (REPTotalPrevYearREP "an increase" "a decrease") }

I don't anticipate the numbers ever being the same. For some reason, no
matter what numbers I use, the field ALWAYS displays "an increase". The field
is not locked, and I have been updating it after changing the numbers.

What am I doing wrong?

macropod,

Thank you sooooooo much, it works perfectly now!!

"macropod" wrote:

Hi CPelkey,

Instead of an IF test, try something along the lines of:
{={ REPTotal }-{ PrevYearREP } \# "'an increase';'a decrease';'no change'"}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[Microsoft MVP - Word]


"CPelkey" wrote in message ...
I have a form where the user enters the number of reports for the current
year as well as the number of reports for the previous year. I want to use
this information to automatically tell the user whether the number of reports
has increased or decreased.

REPTotal is the total reports for the current year
PrevYearREP is the number of reports for the previous year.

Here is the IF statement I am using:

{ IF (REPTotalPrevYearREP "an increase" "a decrease") }

I don't anticipate the numbers ever being the same. For some reason, no
matter what numbers I use, the field ALWAYS displays "an increase". The field
is not locked, and I have been updating it after changing the numbers.

What am I doing wrong?

.

Clever!

--
Stefan Blom
Microsoft Word MVP



"macropod" wrote in message
...
Hi CPelkey,

Instead of an IF test, try something along the lines of:
{={ REPTotal }-{ PrevYearREP } \# "'an increase';'a decrease';'no
change'"}

Note: The field brace pairs (ie '{ }') for the above example are created
via Ctrl-F9 - you can't simply type them or copy & paste them from this
message.

--
Cheers
macropod
[Microsoft MVP - Word]


"CPelkey" wrote in message
...
I have a form where the user enters the number of reports for the current
year as well as the number of reports for the previous year. I want to
use
this information to automatically tell the user whether the number of
reports
has increased or decreased.

REPTotal is the total reports for the current year
PrevYearREP is the number of reports for the previous year.

Here is the IF statement I am using:

{ IF (REPTotalPrevYearREP "an increase" "a decrease") }

I don't anticipate the numbers ever being the same. For some reason, no
matter what numbers I use, the field ALWAYS displays "an increase". The
field
is not locked, and I have been updating it after changing the numbers.

What am I doing wrong?