Then double-click the fill-down handle again. If the percentage is an increase then add it to 100, if it is a decrease then subtract it from 100. To increase the amount by 25%, simply replace the + sign in the formula in cell D2 sign to a minus ( -): Step 1) Get the percentage of the original number. You get the results in all of the other cells without retyping or copying-and-pasting the formula. To copy the formula in cell D2 down the column, double-click the small square green box in the lower-right corner of cell D2.
The result is multiplied by B2 to get a result of 56.25 for Week 1. The values inside the parentheses calculate first, so ther value of C2 is subtracted from 1, to give us 75%. In this formula, 1 is equivalent to 100%. Here's is a formula you could enter in cell D2 to accomplish this: In this example, we set column B to contain the amount currently spent, and column C is the percentage by which to reduce that amount. To calculate the amount, use a formula to subtract or add a percentage. Let's say you need to decrease-or want to increase-your weekly food expenditures by 25%. Next, use the subtraction sign to deduct and enter the percentage value that you want to decrease. After that, enter the closing parentheses and enter 100. Note: If you need to find the percentage of a total or find the percentage of change between two numbers, you can learn more in the article Calculate percentages. Formula to Subtract or Decrease a Value by a Percentage First, enter in a cell and refer to the cell with the original value.
0 kommentar(er)
