Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 04-08-2018, 04:58 PM
macropod's Avatar
macropod macropod is offline Microsoft Word Field Maths Tutorial Windows 7 64bit Microsoft Word Field Maths Tutorial Office 2010 32bit
Administrator
Microsoft Word Field Maths Tutorial
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,953
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default Microsoft Word Field Maths Tutorial

Attached is a document I've created to show how to do various mathematical calculations using Word fields, including some possibilities for string testing & manipulation. Topics covered include:

• Formula Field Syntax
• Formula Field Arithmetic Operators
• Formula Field Comparison Operators
• Formula Field Functions
• Formula Field Logical Functions
. AND And OR: Testing Multiple Logical Numeric Expressions
. Testing Negative Numbers
. Testing Or Returning Text Strings With Logical Functions In Bookmarks
• Calculations In Word Forms
• Referencing Cells In A Table
. Identifying Cell Addresses
. Referencing Cells Containing Numbers
. Referencing Cells Containing Text
. Reference Operators
. Referencing An Entire Row Or Column
. Referencing Adjacent Cells In A Row Or Column


. Relative Referencing In Tables
. Testing Or Returning Cell Contents In Tables
. Reference Table Cells From Outside The Table
. Referencing Row And Column Totals From Outside A Table
• Formatting Numeric Field Results
• Rounding Numbers To The Nearest Multiple
• Rounding Numbers Up Or Down
• Superscripted Ordinal Numbers
• Parsing Numbers Separated By + Or - Signs
• Scientific Notation
• Logarithms
• Trigonometry
• Financial Calculations

Enjoy

Note: Any discussions should be made in a new thread - they cannot be added to this one.
Attached Files
File Type: zip Word Field Maths.zip (61.9 KB, 618 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Closed Thread

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Word Field Maths Tutorial Microsoft Word Date Calculation Tutorial macropod Word 0 04-08-2018 04:57 PM
Microsoft Word Field Maths Tutorial Microsoft Word VBA to save Word doc to separate PDF files using a Mail Merge field as File name meghanquint4 Word VBA 2 02-28-2018 07:12 AM
Word and Excel 2002/2003/2007 Tutorial tennythomas Word 1 09-03-2011 11:05 AM
Is there a graphic tutorial available on how the Word 2007 ruler works? Jenjen80 Word 0 07-13-2010 07:41 PM
Word Macro Tutorial Jax Word VBA 0 04-27-2010 09:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft