Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
gatz gatz is offline
external usenet poster
 
Posts: 4
Default Trig functions for Formulas in Tables


I've been trying to get this formula to work in a table of 4 columns x 10
rows...

{=b2*(sec” 30) }

There's a value of .4375 in b2 and I want to multiply it by sec 30 (or,
1/cos 30) and show the results in the last cell of that row; d2

When I put the formula in that cell and hit Enter, I keep getting "SYNTAX
Error" but have no idea how these trig functions should be entered.

If there's a simple multiplication formula entered instead; say { = b2 *
12}, after hitting Enter, there's a dialog box that comes up, and Update
Field can be clicked on to evaluate the cell which gives a correct answer.
However, entering the trig function formula doesn't show that dialog box.

How are trig funtions supposed to be entered? Anyone know?
  #2   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP on news.microsoft.com Doug Robbins - Word MVP on news.microsoft.com is offline
external usenet poster
 
Posts: 407
Default Trig functions for Formulas in Tables

Formulae in Word tables are pretty much limited to the user of the basic
mathematical operators +, -, *, /

So, if my knowledge of trig functions has not gone astray, you could use

{ = b2 * 2 / 1.732 }

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"gatz" wrote in message
news

I've been trying to get this formula to work in a table of 4 columns x 10
rows...

{=b2*(sec? 30) }

There's a value of .4375 in b2 and I want to multiply it by sec 30 (or,
1/cos 30) and show the results in the last cell of that row; d2

When I put the formula in that cell and hit Enter, I keep getting "SYNTAX
Error" but have no idea how these trig functions should be entered.

If there's a simple multiplication formula entered instead; say { = b2 *
12}, after hitting Enter, there's a dialog box that comes up, and Update
Field can be clicked on to evaluate the cell which gives a correct answer.
However, entering the trig function formula doesn't show that dialog box.

How are trig funtions supposed to be entered? Anyone know?



  #3   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Trig functions for Formulas in Tables

Hi gatz,

To see how to coerce Word into performing trigonometric calculations,plus a wide range of other calculations in Word, check out my
Word Field Maths Tutorial, at:
http://www.wopr.com/index.php?showto...#entry365 442
or
http://www.gmayor.com/downloads.htm#Third_party


--
Cheers
macropod
[MVP - Microsoft Word]


"gatz" wrote in message news

I've been trying to get this formula to work in a table of 4 columns x 10
rows...

{=b2*(sec” 30) }

There's a value of .4375 in b2 and I want to multiply it by sec 30 (or,
1/cos 30) and show the results in the last cell of that row; d2

When I put the formula in that cell and hit Enter, I keep getting "SYNTAX
Error" but have no idea how these trig functions should be entered.

If there's a simple multiplication formula entered instead; say { = b2 *
12}, after hitting Enter, there's a dialog box that comes up, and Update
Field can be clicked on to evaluate the cell which gives a correct answer.
However, entering the trig function formula doesn't show that dialog box.

How are trig funtions supposed to be entered? Anyone know?


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
Using formulas in tables Shayla2008 Tables 5 February 18th 09 05:21 AM
Formulas in Tables kr Tables 1 February 20th 07 09:51 PM
Tables and Formulas in Forms Bert0529 Tables 1 October 13th 06 09:16 PM
FORMULAS IN TABLES STOBBSNET1 New Users 6 February 27th 06 09:30 PM
Tables/Formulas smithy23 Tables 1 August 22nd 05 06:03 PM


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