Results 1 to 1 of 1
  1. #1
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,806
    Thanks
    0
    Thanked 166 Times in 153 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 19:39. Reason: Additional content
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

Posting Permissions

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