Results 1 to 1 of 1
  1. #1
    Super Moderator
    Join Date
    May 2002
    Canberra, Australian Capital Territory, Australia
    Thanked 467 Times in 380 Posts

    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
    Financial Calculations

    This post replaces an old thread from when the tutorial was first created.


    Note: Any discussions should be made in a new thread - they cannot be added to this one.
    Attached Files Attached Files
    Last edited by macropod; 2014-02-06 at 20:39. Reason: Additional content

    Paul Edstein
    [MS MVP - Word]

  2. The Following 6 Users Say Thank You to macropod For This Useful Post:

    Danci007 (2015-09-29),dooser (2015-10-12),fiberboysa (2017-02-09),IJC (2016-08-18),jaymanwitt (2016-06-06),Kelsh (2018-04-23)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts