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 / Tables / August 2007

Tip: Looking for answers? Try searching our database.

Formulas 3 Ways

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lenny - 29 Aug 2007 21:28 GMT
In Word 2003, calculations can be placed into a table cell in at least 3 ways:
1.  On the Insert dropdown as insert field  and select =(Formula) (Note:  
this does not insert a form field, just the code)
2.  On the Table dropdown by selecting 'Formula' (which does insert a form
field)
3.  On the Forms Toolbar by selecting 'Text Form Field' and from the
dropdown, change the definition to 'Calculation'.

Why three different ways of adding a calculation?  Are there instances where
one is preferable over another?  Do the differences affect the manner in
which the calculation is handled (i.e., form field vs no form field)?  I can
see that the two methods that actually drop in a form field provide an
opportunity to add a bookmark that the first method does not.....

Does anyone have an explanation or is there an explanation?

best regards - Lenny
Tom Conrad - 30 Aug 2007 00:12 GMT
Many of the functions within Microsoft programs, e.g., windows, Office suite,
etc., have multiple access paths. This is more a reflection of the programs
lineage, as well as a reflection of the microsoft sales and marketing
strategies than of functionality.

In the days of MS-DOS, the power users acquired personal memories filled
with command line syntax and keyboard shortcuts. When Apple software began to
capture market share because of the GUI interface, then microsoft gave us
windows. New users learned to point and click, command line junkies, despised
that it took repetitive roll, click, roll, click, roll click, ad infinitium
cycles to execute a function that previouly took a three key command.

As Win and Office continued to develop, and microsoft tried to attract
Wordperfect customers, the programs acquired more menus, more keyboard
shortcuts, more submenus, ....  

An Iconic interface using toolbars (or the ribbon) can be easier for new
users. It is often a pain in the keester for more advanced users, as it
requires the advanced user to drill down through multiple and redundant
layers to perform a function.

Regarding multi-paths, some of the paths provide higher levels of control or
assistance for the less experienced user. Many experienced users utilize
keyboard shortcuts, macros, etc. to reduce the mileage on their mouse, and to
reduce wear and tear on their index finger.

A formula Field code executes the same regardless of the entry method.  

Signature

Tom Conrad

===


> In Word 2003, calculations can be placed into a table cell in at least 3 ways:
> 1.  On the Insert dropdown as insert field  and select =(Formula) (Note:  
> this does not insert a form field, just the code)

> 2.  On the Table dropdown by selecting 'Formula' (which does insert a form
> field)

> 3.  On the Forms Toolbar by selecting 'Text Form Field' and from the
> dropdown, change the definition to 'Calculation'.
[quoted text clipped - 8 lines]
>
> best regards - Lenny
 
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.