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 • Decatur, AL • El Segundo, CA • Fresno, CA • Stamford, CT • Jacksonville, FL • Sharpsburg, GA • Shenandoah, IA • Glenview, IL • Franklin, IN • Plainfield, IN • Frankfort, KY • Franklin, KY • Glasgow, KY • Paducah, KY • Hudson, MA • Jackson, MI • Jackson, MS • Greenville, NC • Sherrills Ford, NC • Omaha, NE • Keene, NH • Fredonia, NY • Great River, NY • Rochester, NY • State College, PA • Brentwood, TN • Chapel Hill, TN • Chattanooga, TN • Clarksville, TN • Decherd, TN • Dickson, TN • Franklin, TN • Gladeville, TN • Hickman, TN • Jackson, TN • La Vergne, TN • Lebanon, TN • Madison, TN • Mt Juliet, TN • Mt. Juliet, TN • Mt. Pleasant, TN • Old Hickory, TN • Pleasant View, TN • Shelbyville, TN • Sparta, TN • Spencer, TN • Fredericksburg, VA • Quantico, VA • Racine, WI

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