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, 09:50 PM

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

alright, here's the thing.

in column A

in A1, the formula i put is =200*B1
in A2, the formula is =200*H1
in A3, =200*O1
A4, = 200*U1

the sequence here is that from B1 to H1 to O1 to U1... are all 6 horizontal cells away each.

how to i do it? what formula do i put in column A

Thank you

« 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 09:58 PM.