View Single Post
 
Old 04-08-2018, 04:58 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,562
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
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, 212 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]