Thread: how to write G1 in terms of B1+value in the cell 5 columns away (which is G1 itself))
View Single Post
 
Old 04-19-2012, 10:52 AM
Sunny Sunny is offline Windows XP Office 2007
Novice
  
Join Date: Apr 2012
Posts: 6
Sunny is on a distinguished road
Default how to write G1 in terms of B1+value in the cell 5 columns away (which is G1 itself))
for example

i want

A1 to be = G1 (but i want to write G1 in terms of B1+value in the cell 5 columns away)

and then
A2 = G2 (but i want to write G2 in terms of B2+value in the cell 5 columns away)

and then i will drag it down for many many rows

thank you
Last edited by Sunny; 04-19-2012 at 10:54 AM. Reason: i was mistaken
Reply With Quote