Tips.Net > WordTips Home > Macros > VBA Examples > Deriving an Absolute Value
Deriving an Absolute Value
Summary: Want to know the absolute value of a number? It’s easy to derive in VBA by using the Abs function. (This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.)
VBA provides a function to return the absolute value of an expression. For those who might not remember from math class, an absolute value is the positive equivalent of any expression. Thus, if a formula would normally result in a negative value, such as –27, the absolute value of that formula would result in the positive equivalent, or 27.
The syntax for the absolute value function is as follows:
x = Abs(y)
where x is the result and y is a value or an expression that evaluates to a value.
Tip #1898 applies to Microsoft Word versions: 97 2000 2002 2003 2007
Create and Merge! Using Word's mail merge tool you can quickly and easily combine data from a variety of data sources to create great individualized documents that incorporate your data in ways that you control. WordTips: Mail Merge Magic is an invaluable source for learning how to harness the full power of Word's mail merging capabilities.
Check out WordTips: Mail Merge Magic today!
Fast Answers!
It doesn't matter if you are a beginner or expert, the WordTips archives are the fastest way to improved productivity. (more information...)
Helpful Links
Ask a Word Question
Make a Comment
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips