Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #14   Report Post  
Dawn Rhoads
 
Posts: n/a
Default

Thanks again for your help Greg and Charles! I still don't know what the
problem was, but I had difficulty getting any of Greg's formulas to work at
all. I was probably doing something wrong. I also lost my internet
connection for about a day so couldn't access the newsgroup to ask for more
help. What bad timing! I was able to find someone here at work who came up
with a way of accomplishing our goal, which I'm posting in case anyone else
is interested in this thread.

We used a field for the user to type in the total pages (bookmarked as
"totalpages", and the number 100 in a second column (bookmarked "pagesfree").
This was mostly for user-friendliness, so they could see what numbers were
being used. Then he was able to make a field that subtracted pagesfree from
the total pages, divided that total by 50. Now here's the tricky part: he
added 0.49 to the result and rounded the resulting number. Adding the 0.49
has the effect of making the "round" function into a "round up" function. It
works! Sneaky.

Here's the field we used:

{=MAX(ROUND(0.49+((totalpages-pagesfree/50),0),0)\*MERGEFORMAT}

Thanks again for the time you spent helping me, I appreciate it. Hope this
might help anyone else with this issue.

Thanks,
Dawn
 
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
form and form field formatting stacyo Microsoft Word Help 4 December 8th 04 04:52 PM
Text Form Field Ref in Footer Won't Update on Screen StarWine Microsoft Word Help 3 December 6th 04 06:17 PM
Prevent double quote in form field Peter Thys Microsoft Word Help 1 December 6th 04 01:14 PM
Form Field Automation Mitch Microsoft Word Help 2 November 29th 04 07:29 PM
Field code # characters (no spaces) FOR SPECIFIC DOC SECTION Christian Microsoft Word Help 1 November 28th 04 06:14 PM


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

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

About Us

"It's about Microsoft Word"