Results 1 to 1 of 1
  1. #1
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,947
    Thanks
    0
    Thanked 204 Times in 185 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
    • Logarithms
    • Trigonometry
    • Financial Calculations

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

    Enjoy

    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
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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