Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Tywardreath Tywardreath is offline
external usenet poster
 
Posts: 4
Default Formula from Excel to Word

Hi

How would I change this formula

=IF(A110,(A1-10&" over"),(10-A1&" under"))

to something suitable in Word? I'm assuming that A1 is a bookmarked value.

Thanks, Ty.

  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Tywardreath Tywardreath is offline
external usenet poster
 
Posts: 4
Default Formula from Excel to Word

I found something that works... this is what I did

{ if { wordcount } 10 "{ = { wordcount } - 10} over" "{= 10 - { wordcount
}} under"}


  #3   Report Post  
Posted to microsoft.public.word.docmanagement
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default Formula from Excel to Word

Hi Tywardreath,

You could also use something like:
{={wordcount}-10 \# "# over;# under"}
or
{={wordcount}-10 \# "# over;# under;balanced"}

Cheers

--
macropod
[MVP - Microsoft Word]


"Tywardreath" wrote in message
...
I found something that works... this is what I did

{ if { wordcount } 10 "{ = { wordcount } - 10} over" "{= 10 - {

wordcount
}} under"}




  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Tywardreath Tywardreath is offline
external usenet poster
 
Posts: 4
Default Formula from Excel to Word

Thanks - that is a much better solution.

Cheers, Ty.

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
Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 22 May 20th 23 08:51 PM
Converting WordPerfect 12 files to Word 2003 Curious New Users 4 May 19th 23 02:48 PM
hard space between words. Sandy L Microsoft Word Help 7 May 5th 06 08:25 PM
Word should allow to 'divide' page by 3 or 4, not just 2 CandasK Page Layout 2 February 28th 06 10:16 PM
How can Word display full path of a file in the title bar? SAsif Microsoft Word Help 1 January 26th 06 04:32 PM


All times are GMT +1. The time now is 12:07 PM.

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"