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 • Hampton Cove, AL • Harrison, AR • San Bernadino, CA • Jacksonville, FL • Patrick AFB, FL • Gainesville, GA • Lawrenceville, GA • Carbondale, IL • Danville, IL • Mattoon, IL • Naperville, IL • Taylorville, IL • Lafayette, IN • Campbellsville, KY • Paducah, KY • Lafayette, LA • Galesburg, MI • Jackson, MI • Jackson, MS • Cashiers, NC • Fairview, NC • Raleigh, NC • Washington, NC • Carlsbad, NM • Canby, OR • San German, PR • Carthage, TN • Fayetteville, TN • Gainesboro, TN • Gallatin, TN • Jackson, TN • La Vergne, TN • LaVergne, TN • Lawrenceburg, TN • Madison, TN • Manchester, TN • Martin, TN • McKenzie, TN • Nashville, TN • Oak Ridge, TN • Paris, TN • Parsons, TN • Tazewell, TN • Watertown, TN • Waverly, TN • Haltom City, TX • San Antonio, TX • Manchester Center, VT • Racine, WI

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