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—2014

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 • Birmingham, AL • Decatur, AL • Florence, AL • Blytheville, AR • El Segundo, CA • Denver, CO • Alpharetta, GA • Atlanta, GA • Duluth, GA • Bloomington, IL • Carbondale, IL • Chicago, IL • Danville, IL • Bowling Green, KY • Campbellsville, KY • Detroit, MI • Fenton, MI • Columbia, MO • Biloxi, MS • Asheville, NC • Cashiers, NC • Fairview, NC • Carlsbad, NM • Akron, OH • Brook Park, OH • Cincinnati, OH • Cuyahoga Falls, OH • Canby, OR • Alexandria, TN • Antioch, TN • Arnold AFB, TN • Arnold Air Force Base, TN • Arrington, TN • Ashland City, TN • Brentwood, TN • Carthage, TN • Chapel Hill, TN • Chattanooga, TN • Clarksville, TN • Cleveland, TN • Clinton, TN • Collegedale, TN • Columbia, TN • Cookeville, TN • Decherd, TN • Dickson, TN • Fayetteville, TN • Arlington, VA • Big Stone Gap, VA

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