Then double-click the fill-down handle again. To increase the amount by 25%, simply replace the + sign in the formula in cell D2 sign to a minus ( -): 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. Step 3: Drag the formula until the end of the required data column. Step 2: Enter the address of the cells to be subtracted with the minus sign. When you use cell references in a formula instead of the cell value, you can change the value without having to change the formula. The result is multiplied by B2 to get a result of 56.25 for Week 1. Step 1: Select the cell where you want the result to appear. A cell reference combines the column letter and row number, such as A1 or F345. 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%. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |