How do I use a variable in a cell reference?

jsp377

Posts: n/a

How do I use a variable in a cell reference?

I'm trying to reference a cell using other cells, for example: B(60-A30),
which is to mean reference the cell in the Bth column, and the (60-A30)th
row. How do I do this in Excel 2000?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Maintaining cell reference after sorting	GRITS	Excel Discussion (Misc queries)	2	April 30th 23 07:42 PM
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable.	[email protected]	Excel Worksheet Functions	2	December 11th 04 12:05 AM
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable	[email protected]	Excel Worksheet Functions	2	December 11th 04 12:00 AM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM
can you use a variable or cell reference in a getpivotdata formul.	stevec	Excel Worksheet Functions	1	November 8th 04 09:20 PM

All times are GMT +1. The time now is 10:02 PM.

Menu

About Us