Subtracting 90% in Excel

Excel Formula for Subtracting 90%

Formula Structure

To subtract 90% from a value in Excel, you can use the following formula:

= A1 * (1 - 0.9)

Explanation of the Formula

• A1: This represents the cell containing the original value from which you wish to subtract 90%. You will replace A1 with the actual cell reference you are using.
• (1 - 0.9): This calculates the remaining percentage after subtracting 90%, which is 10% or 0.1 in decimal form. Thus, multiplying the original value by this result gives you 10% of the original value.

Practical Example

Suppose you have a value in cell A1 that is 200. You want to find out what 10% of this value is after subtracting 90%.

1. In cell A1, input the value 200.
2. In another cell (e.g., B1), enter the formula:

   = A1 * (1 - 0.9)

3. The result in cell B1 will be 20, which is 10% of 200.

Summary

This Excel formula effectively allows you to subtract 90% from any given value and is useful in financial analysis, budgeting, and other scenarios where percentage calculations are necessary. For comprehensive learning on such formulas, consider exploring the courses available on Enterprise DNA Platform.