KimiCode: DS-00024-QM

Microsoft Excel Calculate Difference as a Percentage

Microsoft-Excel-Calculate-Difference-As-Percentage

Use the subtraction (-) and division (/) operators, and the ABS function to do this task.

The formula =(B2-A2)/ABS(A2) will produce .25; format it to a percent and you're done.

About the ABS Function:

The ABS function returns the absolute value of a number. The absolute value of a number is the number without its sign.

Syntax: ABS(number) Number is the real number of which you want the absolute value.

For example, the absolute value of -5 is 5.


611 Potomac Place • Suite 101 • Smyrna, Tennessee 37167 • 615.223.6789 • ContactUs@DataSchenk.com
Classes • Training • Nashville • © 1998—2015

We Offer • SQL Server Training • Exchange Server Training • C Sharp Training • VB.NET Training • Javascript Training
• SSAS Training • SSIS Training • SSRS Training • Project Training • SharePoint Training • Access Training • Excel Training

We have Customers in • Florence, AL • Fort Smith, AR • El Segundo, CA • San Bernadino, CA • Denver, CO • Pensacola, FL • West Palm Beach, FL • Alpharetta, GA • Kennesaw, GA • Lawrenceville, GA • Roswell, GA • Iowa City, IA • Shenandoah, IA • Chicago, IL • Campbellsville, KY • Fort Campbell, KY • Golden Pond, KY • Paducah, KY • Princeton, KY • Russellville, KY • Minden, LA • Fort Bragg, NC • Omaha, NE • Keene, NH • Reno, NV • Ithica, NY • Rome, NY • New Concord, OH • State College, PA • Fort Mill, SC • Alexandria, TN • Ashland City, TN • Chapel Hill, TN • Cleveland, TN • Collegedale, TN • Decherd, TN • Gallatin, TN • Hendersonville, TN • La Vergne, TN • Lawrenceburg, TN • Minneapolis, TN • Shelbyville, TN • Spencer, TN • Tullahoma, TN • White House, TN • Woodbury, TN • San Antonio, TX • Fredericksburg, VA • Fort Lewis, WA

ROBROY — /DS-00024-QM/Microsoft-Excel-Calculate-Difference-As-Percentage/