I have a couple actions I'd like to do in a weight loss Excel spreadsheet but need your help. 1. The cells in column A are for weekly weigh-ins. I use a simple formula to calculate the loss or gain from the previous week by using =B11-B12 in the B column right next to the current weigh-in. Problem is if I enter that formula for a range in the B column it will display the last weigh-in from the A column for the whole range. What I'd like to see is the cells under the last loss/gain calculation column blank, instead of displaying the working formula (even though the formula exists in those cells). Make sense? Right now when I enter a new weigh-in I also have to enter the gain/loss formula right next to it. I'd like to pre-load the formula in the B column but only have it operate when a new weigh-in is entered. 2. I also have a pre-set Goal Weight in D7, and the sum of the B column that shows the total weight loss in C7. I'd like to calculate the percentage of the goal that has been achieved in E7. Any help? Thanks-
Hi eagleout, First thing you'll need to do is add an IF statement in your C column. You'll need something similar to: =IF(A1="","",A1) This tests if A1 is blank, if it is, display nothing, otherwise display value of A1 (substitute your formula in here). The format of the IF statement is =IF(test condition, value if true, value if false). The next bit is even easier, in E7, just enter =C7/D7 This will return your percentage (you may need to alter the format of the cell by right-clicking on E7 > Format cells > Select percentage category from the list. Hope that helps.