how to write G1 in terms of B1+value in the cell 5 columns away (which is G1 itself))

		Microsoft Office Forums > Microsoft Excel > Excel
how to write G1 in terms of B1+value in the cell 5 columns away (which is G1 itself))

FAQ

Thread Tools

Display Modes

04-19-2012, 10:52 AM

Sunny

Windows XP how to write G1 in terms of B1+value in the cell 5 columns away (which is G1 itself))

Office 2007

Novice

Join Date: Apr 2012

Posts: 6

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need macro to make list of "defined terms"	glnz	Word VBA	8	09-07-2022 02:09 PM
How can I write the following (whole) formula in a single cell?	Learner7	Excel	1	07-19-2010 10:06 AM
How to compare 2 columns with other two columns in EXECL 2007?	Learner7	Excel	5	06-12-2010 09:54 AM
I am trying to discover how to write a comm. Add-in	patc4	Office	1	06-16-2009 11:11 AM
terms of use	heidi	Misc	0	01-15-2007 03:01 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:59 PM.