![]() ![]() 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%. 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 |