Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
BigPig
 
Posts: n/a
Default If Formula syntax error

={IF{bkmrk2}="E7""SFC""None"}
Everytime I try this or a variation of it, I get a syntax error.

The form is in a table, and what I want it to do, is autimatically fill in
other cells in the same table (on different pages) with the same data (text)
or replace certain text phrases with others.

The specifc action requested for the above formula is this: In a different
cell of the same table, I want to replace (the grade) "E7" with (the rank)
"SFC" for the purposes of creating a signature block.

Please Help! Thanks!
  #2   Report Post  
Posted to microsoft.public.word.tables
Cindy M -WordMVP-
 
Posts: n/a
Default If Formula syntax error

Hi ?B?QmlnUGln?=,

={IF{bkmrk2}="E7""SFC""None"}
Everytime I try this or a variation of it, I get a syntax error.

Try this. Note the SPACES (sometimes, Word gets finicky in formulas). Also make
sure you've pressed Ctrl+F9 to create the field brackets { }

{ IF { REF bkmrk2 } = "E7" "SFC" "None" }

Note that = (if you're using this in a field calculation) only works with
numbers, not text. Since the result of the IF field will be text, you shouldn't
be using an equals sign or a calculation field, just the IF field.

The form is in a table, and what I want it to do, is autimatically fill in
other cells in the same table (on different pages) with the same data (text)
or replace certain text phrases with others.

The specifc action requested for the above formula is this: In a different
cell of the same table, I want to replace (the grade) "E7" with (the rank)
"SFC" for the purposes of creating a signature block.


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

  #3   Report Post  
Posted to microsoft.public.word.tables
BigPig
 
Posts: n/a
Default If Formula syntax error

Hi Cindy,

Thanks for the help! However what I got after toggling was "REF" (minus the
quotations). Then I tried it without the "REF" and I got "bkmrk2".
Do you have any suggestions?

Thankyou in advance!


"Cindy M -WordMVP-" wrote:

Hi ?B?QmlnUGln?=,

={IF{bkmrk2}="E7""SFC""None"}
Everytime I try this or a variation of it, I get a syntax error.

Try this. Note the SPACES (sometimes, Word gets finicky in formulas). Also make
sure you've pressed Ctrl+F9 to create the field brackets { }

{ IF { REF bkmrk2 } = "E7" "SFC" "None" }

Note that = (if you're using this in a field calculation) only works with
numbers, not text. Since the result of the IF field will be text, you shouldn't
be using an equals sign or a calculation field, just the IF field.

The form is in a table, and what I want it to do, is autimatically fill in
other cells in the same table (on different pages) with the same data (text)
or replace certain text phrases with others.

The specifc action requested for the above formula is this: In a different
cell of the same table, I want to replace (the grade) "E7" with (the rank)
"SFC" for the purposes of creating a signature block.


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)


  #4   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill
 
Posts: n/a
Default If Formula syntax error

Are you inserting all the fields using Ctrl+F9?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"BigPig" wrote in message
...
Hi Cindy,

Thanks for the help! However what I got after toggling was "REF" (minus

the
quotations). Then I tried it without the "REF" and I got "bkmrk2".
Do you have any suggestions?

Thankyou in advance!


"Cindy M -WordMVP-" wrote:

Hi ?B?QmlnUGln?=,

={IF{bkmrk2}="E7""SFC""None"}
Everytime I try this or a variation of it, I get a syntax error.

Try this. Note the SPACES (sometimes, Word gets finicky in formulas).

Also make
sure you've pressed Ctrl+F9 to create the field brackets { }

{ IF { REF bkmrk2 } = "E7" "SFC" "None" }

Note that = (if you're using this in a field calculation) only works

with
numbers, not text. Since the result of the IF field will be text, you

shouldn't
be using an equals sign or a calculation field, just the IF field.

The form is in a table, and what I want it to do, is autimatically

fill in
other cells in the same table (on different pages) with the same data

(text)
or replace certain text phrases with others.

The specifc action requested for the above formula is this: In a

different
cell of the same table, I want to replace (the grade) "E7" with (the

rank)
"SFC" for the purposes of creating a signature block.


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question

or reply
in the newsgroup and not by e-mail :-)



  #5   Report Post  
Posted to microsoft.public.word.tables
BigPig
 
Posts: n/a
Default If Formula syntax error

That was it! Thanks.

Now my question is how can it be made to update automatically? As opposed to
right clicking and selecting update. I think that I should make this form in
excel instead. But if you have any suggestions that would be great!

Thanks!

"Suzanne S. Barnhill" wrote:

Are you inserting all the fields using Ctrl+F9?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"BigPig" wrote in message
...
Hi Cindy,

Thanks for the help! However what I got after toggling was "REF" (minus

the
quotations). Then I tried it without the "REF" and I got "bkmrk2".
Do you have any suggestions?

Thankyou in advance!


"Cindy M -WordMVP-" wrote:

Hi ?B?QmlnUGln?=,

={IF{bkmrk2}="E7""SFC""None"}
Everytime I try this or a variation of it, I get a syntax error.

Try this. Note the SPACES (sometimes, Word gets finicky in formulas).

Also make
sure you've pressed Ctrl+F9 to create the field brackets { }

{ IF { REF bkmrk2 } = "E7" "SFC" "None" }

Note that = (if you're using this in a field calculation) only works

with
numbers, not text. Since the result of the IF field will be text, you

shouldn't
be using an equals sign or a calculation field, just the IF field.

The form is in a table, and what I want it to do, is autimatically

fill in
other cells in the same table (on different pages) with the same data

(text)
or replace certain text phrases with others.

The specifc action requested for the above formula is this: In a

different
cell of the same table, I want to replace (the grade) "E7" with (the

rank)
"SFC" for the purposes of creating a signature block.


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question

or reply
in the newsgroup and not by e-mail :-)






  #6   Report Post  
Posted to microsoft.public.word.tables
Cindy M -WordMVP-
 
Posts: n/a
Default If Formula syntax error

Hi ?B?QmlnUGln?=,

Now my question is how can it be made to update automatically? As opposed to
right clicking and selecting update. I think that I should make this form in
excel instead.

There's really no way to get Word to automatically update formulas (or other
fields), except by activating the option for printing.

Ctrl+A, F9 is usually pretty good. Or you could use a macro (to only update
fields in a certain range, for example). Even more "sophisticated" would be a
macro based on EVENTS, such as when the selection changes; this can get a bit
complicated, however.

So, yes, if you need dynamic calculations, Excel is definitely the better
application :-)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to Sum values in word table Craig Mailmerge 1 August 29th 05 06:19 PM
Help! I'm getting error messages too much-can't open Resume Wizard LizLB Microsoft Word Help 0 May 3rd 05 01:46 AM
Data Execution Prevention Error Frank Microsoft Word Help 0 April 27th 05 03:33 AM
Error Message on Opening Word Suzi Microsoft Word Help 2 February 21st 05 10:53 PM
Table of Footnotes giving "Error! No table of figures entries found" error? Kevin Walton Tables 2 February 17th 05 10:25 PM


All times are GMT +1. The time now is 12:09 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"