Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 11-09-2012, 01:13 PM
macropod's Avatar
macropod macropod is offline Bookmarking Formula Results Windows 7 64bit Bookmarking Formula Results Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,512
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Because you're using DollaText, the field output is text and you'll not be able to use the bookmarked result as the input to another formula. However, a change to the field code will allow you to overcome that. Simplify the calculation and embed it in its own field, thus:
{={=settlefee*0.75-costs \# 0.00} \*DollarText \*Upper }
and bookmark the portion in red. Note that the braces (ie {}) ecompassing the red portion are field braces, which you create via Ctrl-F9.

Alternatively, create a SET field to hold the calculation and refer to the SET field's bookmark for both purposes:
{SET Result {=settlefee*0.75-costs \# 0.00}}
{REF Result \*DollarText \*Upper} - for the existing output
{=Result-Support \*DollarText \*Upper} - for the additional output
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
allocate 0% to resource results in 99% complete ? Intruder Project 3 02-28-2012 12:58 PM
Bookmarking Formula Results Deleting records/results from mail merge alexb123 Mail Merge 2 08-12-2011 02:27 PM
Search results disappearing Emerogork Office 3 07-17-2011 03:52 PM
Bookmarking Formula Results Sort by criteria: number of results p0k Excel 1 10-22-2009 08:33 PM
filesaveas method for ms project in c# results in error mikimik Project 0 10-12-2006 07:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:49 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft