Q:

What is the percentage increase formula in an Excel spreadsheet?

A:

Quick Answer

While Microsoft Excel does not have a built-in function to find percentage increase between values, a user simply needs to enter the formula "=(B-A)/ABS(A)," where B is the baseline value, and A is the new value. The function "ABS" displays the result in its absolute form, or without a sign.

Continue Reading

Full Answer

If the user prefers, the formula (B-A)-1 may be used with the same parameters as the original, and the same value will be returned. If the user desires a percentage to be displayed, the format of the specific cell can be changed by right-clicking and using the "Number" tab in the "Format Cells" menu.

Learn more about Software

Related Questions

Explore