#1   Report Post  
Posted to microsoft.public.word.newusers
Mark Lewis Mark Lewis is offline
external usenet poster
 
Posts: 8
Default Formula

Hi,

I'm trying to perform a calculation in a form

'Text1' multiply by 'Text2' Divided by 60?

Any help please?

Word help doesn't offer any assistant in calculations!

Thanks

Mark


  #2   Report Post  
Posted to microsoft.public.word.newusers
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Formula

Check the calculate on exit check box of Text2

Insert a form field and set its properties to 'calculated' and in the
calculation area enter

=(Text1 * Text2) / 60

OR

Insert a formula field (not a form field) at the location where you want the
result of the calculation to appear eg

{=({REF Text1} * {REF Text2}) / 60}

Use CTRL+F9 for each bracket pair {} (Note you will get an error if there is
no content in Text1 and Text2.)

OR

Run the following macro on exit from Text2 to write the result of the
calculation in form field Text4

Sub Calc1()
Dim oFld As FormFields
Set oFld = ActiveDocument.FormFields
oFld("Text4").Result = (oFld("Text1").Result * oFld("Text2").Result) /
60
End Sub

Uncheck the Fill in Enabled property of Text4

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Mark Lewis wrote:
Hi,

I'm trying to perform a calculation in a form

'Text1' multiply by 'Text2' Divided by 60?

Any help please?

Word help doesn't offer any assistant in calculations!

Thanks

Mark



  #3   Report Post  
Posted to microsoft.public.word.newusers
Microsmith Microsmith is offline
external usenet poster
 
Posts: 9
Default Formula

Hi Mark

One tool that works great for creating formulas in Word is "Formula Builder
for MS Word". You can find it at most major download sites.


"Mark Lewis" wrote:

Hi,

I'm trying to perform a calculation in a form

'Text1' multiply by 'Text2' Divided by 60?

Any help please?

Word help doesn't offer any assistant in calculations!

Thanks

Mark



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
If formula Duncan Tables 4 August 14th 08 05:47 PM
Need help with a formula jlandes84 Tables 6 January 16th 08 06:32 AM
Formula Roger Tables 3 May 14th 06 06:07 PM
how to align caption of formula right whereas formula itself left Martin van Leeuwen Microsoft Word Help 1 October 22nd 05 06:39 AM
Formula Help Katie Microsoft Word Help 1 September 16th 05 04:02 AM


All times are GMT +1. The time now is 12:08 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"