Microsoft Office Forums Microsoft Word Field Maths Tutorial

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 online now 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: 19,680
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
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, 116 views)
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Closed Thread

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
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


All times are GMT -7. The time now is 04:31 AM.


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