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 • Phoenix, AZ • San Bernadino, CA • Atlanta, GA • Iowa City, IA • Carbondale, IL • Chicago, IL • Lafayette, IN • Golden Pond, KY • Winchester, KY • Lafayette, LA • Minden, LA • O'Fallon, MO • Greenville, NC • Raleigh, NC • Fredonia, NY • Great River, NY • New York, NY • Rome, NY • Cincinnati, OH • Cuyahoga Falls, OH • New Concord, OH • Canby, OR • San German, PR • Gladeville, TN • Goodlettsville, TN • Gordonsville, TN • Hendersonville, TN • LaVergne, TN • Lebanon, TN • Lynchburg, TN • Manchester, TN • McKenzie, TN • Mt. Juliet, TN • Mt. Pleasant, TN • Nolensville, TN • Oak Ridge, TN • Old Hickory, TN • Pleasant View, TN • Pulaski, TN • Sewanee, TN • Waverly, TN • Winchester, TN • Woodbury, TN • San Antonio, TX • Big Stone Gap, VA • Fredericksburg, VA • Lynchburg, VA • Manchester Center, VT

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