Forum Discussion
Need some help with a formula
HansVogelaar this is what happened 😞 Sometimes the cell will be zero also.
stephbuch11 When you copied down you somehow kept the first cell reference as C8. Did you copy down or paste the text in each cell and manually update? I corrected the problem in the attached and added the empty condition to =0.
mtarler ahhhh perfect, and I also see the 0, I tried to do that myself, but put it in the wrong place. Thanks so much!
stephbuch11 You're very welcome. Glad it works. Make sure to give HansVogelaar some Likes for getting you the original formula.
FYI for future. You can copy a formula down (either: a) copy, highlight the whole range and then paste or b) put the cursor on the dot in the bottom right corner and either double-click or drag it over the range or c) highlight the starting cell and the rest of the range and 'Fill Down' (or Right if it is a row)
then you won't have manual typing errors as long as you set up the formula correctly to start. If you do more formulas you will want to learn about how to use a '$' to prevent excel from incrementing those references when you copy/fill down (it makes the reference absolute instead of relative). Excel can do great things, but I don't want to overwhelm you either.
Best of luck and love the company name/logo 🙂
mtarler I thought I did the change-and I did it manually, but maybe did it wrong?
