Monday, December 24, 2012

yogi_SetUp Formula In A Cell So It Can Be Copied In Cells Of Other Rows (relative row referencing)


                                          Google Spreadsheet   Post  #937
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Dec 24, 2012
user Stacy Fatemi said:(http://productforums.google.com/forum/?zx=cmk5k2pk0bbf#!category-topic/docs/spreadsheets/LUz7gW3gv74)
Look up the row of formula, then substitute it in as a variable in that formula
So that if the formula was
=Gx*Fx + Hx*Kx
And it was located in row 4, it would become
=G4*F4 + H4*K4
I want to make a format so that whenever this function is pasted into a different row, the variable x changes to be that row number. Is that possible?
(Firefox 16.0.2, Mac OS X 10.5.8)

--------------------------------------------------------------------------------

If I understand Stacy correctly, Staci needs to setup the formula with RELATIVE REFERENCING for rows ... and I thought it will be best to show that with an illustration as follows .