Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #794 Oct 07, 2012 www.energyefficientbuild.com.
user jocks24 said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/Q-Rvpbo4ePE)
accumulative scores
In a spreadsheet, how do i split a cell in half, ie, / but half the cell with a number in the top half, and an accumulative number in the bottom half. Like cell 1 is 3, cell 2 on the same row is 2/5 which is a score plus the previous score added in bottom half, cell 3 is 1/6, cell 4 is 2/8, cell 5 is 1/9, cell 6 is 3/12.. Does this make sense to anyone? I am on a laptop with Windows 7 and using Google drive spreadsheet. Thanks for any help.
user jocks24 said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/Q-Rvpbo4ePE)
accumulative scores
In a spreadsheet, how do i split a cell in half, ie, / but half the cell with a number in the top half, and an accumulative number in the bottom half. Like cell 1 is 3, cell 2 on the same row is 2/5 which is a score plus the previous score added in bottom half, cell 3 is 1/6, cell 4 is 2/8, cell 5 is 1/9, cell 6 is 3/12.. Does this make sense to anyone? I am on a laptop with Windows 7 and using Google drive spreadsheet. Thanks for any help.
Thick silversurfer, lol
--------------------------------------------------------------------------------------------
following is a single cell arrayformula solution to the problem
No comments:
Post a Comment