Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / November 2005

Tip: Looking for answers? Try searching our database.

Formula Application

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bruno Coelho - 09 Nov 2005 15:48 GMT
Hi everyone,
i having troubles to do an formula in Word. i have a table with three lines.
the 1st it has the VILIQUIDO, the 2nd has IRS and the 3rd has the result. the
Result is (VILIQUIDO*IRS)/100. this VILIQUIDO and IRS are Marker in word
template. the result aren't appear, it appears 0,0
any sugestion
macropod - 09 Nov 2005 21:44 GMT
Hi Bruno,

How are you doing this? Your description of the result suggests you're using
field coding.

You could use a formula field, in the form of:
{=B1*B2/100}
where your row names are in column A and the values are in column B.
Alternatively, you could use:
{=VILIQUIDO*IRS/100}
where 'VILIQUIDO' and 'IRS' are bookmark names. The trick with using
bookmarks in tables is to only bookmark the values - not the whole cells.

Formula fields don't require any vba, but they also don't recalculate
reliably unless you do something explicit to cause them to (eg printing the
document with the 'update fields' property set, or using a protected form
with the 'calculate on exit' property set for each formfield that feeds into
the formula). If you're using vba, you could still use these formulae with a
line like 'ActiveDocument.Fields.Update' in the code.

Cheers

> Hi everyone,
> i having troubles to do an formula in Word. i have a table with three lines.
> the 1st it has the VILIQUIDO, the 2nd has IRS and the 3rd has the result. the
> Result is (VILIQUIDO*IRS)/100. this VILIQUIDO and IRS are Marker in word
> template. the result aren't appear, it appears 0,0
> any sugestion
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.