![]() ![]() Right-click then click “Format Cells” Go to the “Number” tab then choose “Percentage” in the “Category” box. Select all of the cells with formulas in them.Just change the “B” in the formula to the corresponding letter of the column. You may copy then paste the formula from cell B3. Input this formula in each of the cells in row 3.Multiplying by negative 1 in the end creates a positive number. This formula tells gives you the difference between cells B2 and A2 as a percentage amount. Input the formula =(B2-A2)/ABS(A2) _-1 in cell B3.Each week when you take your weight, input the value in the cell in row 2 under the date when you weighed-in. Input your starting weight in cell A2.This copies the formula, entering the dates seven days apart. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |