Writing a "+1" Formula
Posted by Shane Evans on October 09, 2000 10:03 AM
I would like to write a formula in Cell 1R to allow me to do the following...I have a number in Cell 1A that I want divided by 8. I want each consecutive cell in row 1, column B thru Q, to be divided by one more than the cell before it. So, Cell 1A would be divided by 8, Cell 1B would be divided by 8+1, Cell 1C would be divided by 9+1 (or 8+2), Cell 1D would be divided by 10+1 (or 8+3),...