IF statement not working

[CPelkey]

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 (REPTotal>PrevYearREP "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 Blom]

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.

 

[CPelkey]

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]

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.

 

[CPelkey]

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.

 

[Suzanne S. Barnhill]

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

 

[macropod]

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.

 

[CPelkey]

macropod,

Thank you sooooooo much, it works perfectly now!!

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]

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 (REPTotal>PrevYearREP "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 Blom]

Clever!

--
Stefan Blom
Microsoft Word MVP

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]

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 (REPTotal>PrevYearREP "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?