Hello, I tried searching for over 2 hours before I posted. I think this is an easy one and maybe I was searching the wrong words. What I would like to do is increase some numbers across a row. In E4 I have the value .045 which is the starting value. In E5 I have the value .005 which is the amount I want to increase by incrementally. In B8 I type =E4. I want to increase from B8 to C8 by .005 and then increase C8 by .005 etc.....so that going across from B8 to C8 to D8 to E8 to F8...etc the values would increase by .005 each time. What formula should I use to do this? I know if I typed manually it would look like C8=B8+.005 and D8=C8+.005 and E8=D8+.005 etc..but I have a lot to do and this is very cumbersome.
Bookmarks