Google Spreadsheet Post #1681
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jun-27-2014
post by Aaron Stepanik: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/how-do-i/chrome-browser/no/WH-Z2wZgP_E)
=cell + 7 down
I have a cell in B3 for example, and the next relevant cell is 7 cells down from that, B10. How can I write a formula that would =B3 +7cellsdown?
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jun-27-2014
post by Aaron Stepanik: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/how-do-i/chrome-browser/no/WH-Z2wZgP_E)
=cell + 7 down
I have a cell in B3 for example, and the next relevant cell is 7 cells down from that, B10. How can I write a formula that would =B3 +7cellsdown?
It would then look like this:
=B3
=B3+7cellsdown
=B10+7cellsdown
=B17+7cellsdown
Thanks.
------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment