Excel Tips & Tricks – Absolute Value Function

February 19, 2020 by Billie D. Hardison

Excel Tips & Tricks – Absolute Value Function

In today’s blog, we will review how to use the absolute value (ABS) in Excel.

This formula is helpful if you are converting a column of both negative and positive numbers to positive numbers only.

Let’s say column A has a list of numbers beginning in field A2. They are both negative and positive. In column B, enter the formula =abs(A2) and then hit enter. Copy this formula down the entire column. You will now see the absolute value of each of the numbers in column A.

Note: This function typically applies when you are doing calculations that involve distance. It is not very common in the corporate world, but I have used it occasionally.

We love feedback from our customers and implement suggestions often. What shortcut do you use the most? If you have a question or idea for a Microsoft Windows or Excel tip that you would like to see, let me know and I might write about it!

Billie Hardison

Training Specialist

BHardison@advocatecapital.com

Photo Credit: rawpixel

Share this:

About Billie D. Hardison

Billie Hardison is the Director of Operations at Advocate Capital, Inc. She joined Advocate Capital, Inc. in 2012 and has served many roles in finance, technology, and training. Over the years, Ms. Hardison has developed a deep understanding of the company’s proprietary software, AdvoTrac®. She is also proficient in QuickBooks, Intacct, Microsoft products, and many other software programs. Ms. Hardison is dedicated to assisting Advocate Capital clients in all areas of technology and training resources. She has recently joined the AdvoCap Insurance Solutions team, as well.

* In most jurisdictions, a law firm can recover finance charges related to funding case expenses from case awards, but the compliance requirements can be too expensive to implement. Only Advocate Capital, Inc. has the proprietary AdvoTrac^® expense tracking system and service team that allows firms to easily comply with allocation and reporting requirements. So, for example, if a firm recovers at least 90% of its advanced case expenses, like most of our clients, the annual net cost of funds is very small-typically less than 1%. Contact us to discuss how our program can work for your firm. All loans are subject to credit approval, and terms and conditions may vary.

Financial Services provided through Pinnacle Bank, a Tennessee Bank, which is a Member FDIC and Equal Housing Lender. Loans may be subject to credit approval.

Learn about what Advocate Capital, Inc. does with your personal information. Copyright © 2020 Advocate Capital, Inc. • Litigation Expense Funding • All Rights Reserved • Site Map