Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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?
 
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 04:38 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"