Edstein Paul. Microsoft Word Field Maths Tutorial
Windowssecrets.com, 2014. — 20 p.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
