How To Calculate Total Minus Percentage In Excel Complete Guide

The formula in parentheses calculates the percentage which the remainder of the formula subtracts from the original amount. Excel offers us multiple configuration options. Enter values into the blue boxes.

To increase the amount by a percentage use the same formula but simply replace the Plus sign with a Minus sign -.

Thanks to Excel tasks such as calculating the Annual growth rate are very easy to do with percentage formulas. Such skills can be useful in a wide variety of spheres of life. Tips sales price percent off discounted price price with sales tax etc. Finally if you want to know the final cost of a product simply subtract the amount of the discount from the initial amount.