For example, 95% is read as “Ninety-five percent” and is equivalent to 95/100 or 0.95.
Accordingly, the values in column D are decimal values, with thePercentage number formatapplied.
Decrease by percentage
To decrease a number by a specific percentage, you can use a formula that multiplies the number by 1 minus the percentage. In the example shown, the formula in cell E5 is: =C5*(1-D5) The results in column E are decimal values with the percentage number format applied.
